[GENERAL] bytea vs large object in version 8

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 broadc

[GENERAL] large object table space in version 8

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

[GENERAL] dump and restore a single table containing large objects

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 c

Re: [GENERAL] performance difference: multiple db vs single db

Here're two cases - 1. 20 tables in one huge database A on one machine 2. 10 tables in each database if they can functionally separated, so two databases A1 and A2 on one machine What's the estimated performance difference on queries from A2 and A1 comparing the same querying from A in general us

Re: [GENERAL] select distinct w/order by

2004 4:35 PM 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

Re: [GENERAL] select distinct w/order by

ing is black or white, but it's not. The user 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 Li

Re: [GENERAL] select distinct w/order by

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

[GENERAL] build contrib

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

[GENERAL] core dump

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  

Re: [GENERAL] core dump on select

AM 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