jelle wrote:
> The insert heavy sessions average 175 page hits generating XML, 1000
> insert/updates which comprise 90% of the insert/update load, of which
> 200 inserts need to be transferred to the master db. The other
> sessions are read/cache bound. I hoping to get a speed-up from moving
> t
My web app does lots of inserts that aren't read until a session is
complete. The plan is to put the heavy insert session onto a ramdisk
based pg-db and transfer the relevant data to the master pg-db upon
session completion. Currently running 7.4.6.
From what you say I'd think you want to a
On Fri, 11 Mar 2005, Tom Lane wrote:
[ snip ]
COPY would be my recommendation. For a no-programming-effort solution
you could just pipe the output of pg_dump --data-only -t mytable
into psql. Not sure if it's worth developing a custom application to
replace that.
I'm a programming-effort kind of
Sent by: cc:
pgsql-performance@postgresql.org
[EMAIL PROTECTED]Subject: Re: [PERFORM]
Questions about 2 databases.
jelle <[EMAIL PROTECTED]> writes:
> 1) on a single 7.4.6 postgres instance does each database have it own WAL
> file or is that shared? Is it the same on 8.0.x?
Shared.
> 2) what's the high performance way of moving 200 rows between similar
> tables on different databases? Does it matter
Hello All,
I have a couple of questions about running 2 databases:
1) on a single 7.4.6 postgres instance does each database have it own WAL
file or is that shared? Is it the same on 8.0.x?
2) what's the high performance way of moving 200 rows between similar
tables on different databases? Do