Is there a clean way to dump/restore a single table which contains large
objects instead of the entire DB?
In Pg version=7.4 -
pg_dump: Large object output is not supported for a single table.
pg_dump: Use all tables or a full dump instead.
Does version 8.0's pg_dump support a single table dump
Does large object table space is associated with the table (with oid)'s
table space created? If not, what's about table with bytea column?
Thanks.
johnl
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
If speed (add/get) is the only concern, image files could be big (~10M),
and database only serves as storage. In the postgresql 8, which type
(bytea vs large object) is the preferred one? Is it true, in general,
that bytea inserts is slower?
Thanks.
johnl
---(end of
To: [EMAIL PROTECTED]
Subject: Re: [GENERAL] core dump on select
On Fri, Sep 24, 2004 at 03:55:43PM -0500, John Liu wrote:
max memory size (kbytes)32768
open files 2000
pipe size (512 bytes) 64
stack size (kbytes) 2097151
My guess is that one
We upgraded from 7.2 to 7.4, it looks like
everything working, but when I issue a query such as select * from tab (tab has
about 2-3 million records), it causes core dump. I tuned some the parameters,
it still produce the core.
Thanks for any hints.
johnl
How to build some of those contrib? Can you add one of contrib on the
existing Postgresql without reconfigure, rebuild, and reinstall?
Thanks.
johnl
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
To: Tom Lane
Cc: John Liu; [EMAIL PROTECTED]
Subject: Re: [GENERAL] select distinct w/order by
On Wed, 31 Mar 2004, Tom Lane wrote:
John Liu [EMAIL PROTECTED] writes:
The original simple SQL -
select distinct atcode from TMP order by torder;
This is not simple, it is broken SQL
has the choice
at least. But when I use PostgreSQL, I need find an alternative solution to
handle such issue.
johnl
-Original Message-
From: Richard Huxton [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 31, 2004 2:37 PM
To: John Liu; [EMAIL PROTECTED]
Subject: Re: [GENERAL] select
Sorry, the query you provided works in Pg, my mistake :!
select atcode from table group by atcode order by max(torder);
johnl
-Original Message-
From: scott.marlowe [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 31, 2004 4:35 PM
To: Tom Lane
Cc: John Liu; [EMAIL PROTECTED]
Subject: Re