Skip site navigation (1) Skip section navigation (2)

Re: cursor interface to libpq

From: Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu>
To: "Kirby Bohling (TRSi)" <kbohling(at)oasis(dot)novia(dot)net>
Cc: pgsql-interfaces(at)postgresql(dot)org
Subject: Re: cursor interface to libpq
Date: 2000-09-20 16:22:52
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-interfaces
>         Right now I have a database that has right around 4 Million
> rows in the primary table.  I am porting it away from MySQL basically
> because I want transactions.  When the table is written as insert
> statements it is around 3.2Gb, when that is gzipped it comes out to 1.3Gb.
> That table size will probably continue to grow at a rate of 200,000
> rows a week.  I don't know the exact size of each row, but it is under the
> 8K limit.  Right now I am working on a FreeBSD box with 1.5Gb of swap and
> 256MB of Ram.  I believe that I could get that upgraded to 1Gb of ram, and
> add as much swap space as I wanted.  But to be honest I really don't want
> to store every row of every select statement in memory.  I believe that
> the database is around 1.5Gb on disk almost all of it in the one table.

afaik this should all work. You can run pg_dump and pipe the output to a
tape drive or to gzip. You *know* that a real backup will take something
like the size of the database (maybe a factor of two or so less) since
the data has to go somewhere.

Postgres *should* be able to store intermediate results etc on disk, so
the "out of memory" might be due to a per-process limit on your FreeBSD
machine. Others with experience on that platform might have some
specific suggestions.

Scrappy, a FreeBSD partisan, probably has tables on his systems much
bigger than the one under discussion. Perhaps he will speak up here??

Good luck!

                      - Thomas

In response to


pgsql-interfaces by date

Next:From: philippe.benaicheDate: 2000-09-20 18:22:40
Subject: Replication between MS-Access and PostgreSQL
Previous:From: Kirby Bohling (TRSi)Date: 2000-09-20 16:00:47
Subject: Re: cursor interface to libpq

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group