"Axel Waggershauser" <[EMAIL PROTECTED]> writes:
> ... This works quite well for the
> following setups:
> client -> server
> -
> linux -> linux
> linux -> windows
> windows -> windows
> but pretty bad (meaning about 10 times slower) for this setup
> windows -> linux
This h
Hi,
I have written my own 'large object'-like feature using the following table:
CREATE TABLE blob
(
id bigint NOT NULL,
pageno integer NOT NULL,
data bytea,
CONSTRAINT blob_pkey PRIMARY KEY (id, pageno)
)
WITHOUT OIDS;
ALTER TABLE blob ALTER COLUMN data SET STORAGE EXTERNAL;
CREATE SEQUEN
Remember that as you increase shared_buffers you might need to make the
bgwriter more aggressive too.
On Thu, Dec 07, 2006 at 11:42:39AM -0500, Bill Moran wrote:
>
> I'm gearing up to do some serious investigation into performance for
> PostgreSQL with regard to our application. I have two issue
