# enable autovacuum subprocess?
datestyle = 'sql'
lc_messages = 'C' # locale for system error message
lc_monetary = 'C' # locale for monetary formatting
lc_numeric = 'C'# locale for number formatting
lc_time
# typically 8KB each
random_page_cost = 1# units are one sequential page fetch
geqo = off
default_statistics_target = 10 # range 1-1000
log_line_prefix = '%m' # Special values:
autovacuum = on # enable autovacuum subprocess?
datest
tree (leaf_category_1,
site_id) WHERE leaf_category_1 IS NOT NULL
"search_site1_2009_03_13_seller_user_id" btree (seller_user_id,
site_id) WHERE seller_user_id IS NOT NULL
"search_site1_2009_03_13_upc_code" btree (upc_code, site_id) WHERE
upc_code IS NOT NULL
-Origi
09, 2009 11:29 AM
To: Jacob Bresciani
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] FW: Query length limitation in postgres server >
8.2.9
writes:
> leaf_category_1
Ah. So you are wishing it would use this index:
"search_site1_2009_03_13_leaf_category_1" btree (
Being just the server admin I'll forward this thought on to the dev's
for consideration.
-Original Message-
From: Hartman, Matthew [mailto:matthew.hart...@krcc.on.ca]
Sent: Thursday, July 09, 2009 10:58 AM
To: Jacob Bresciani; pgsql-sql@postgresql.org
Subject: RE: [SQL] FW: Qu
Good think I obfuscated it in one place eh :)
leaf_category_1
-Original Message-
From: Tom Lane [mailto:t...@sss.pgh.pa.us]
Sent: Thursday, July 09, 2009 11:14 AM
To: Jacob Bresciani
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] FW: Query length limitation in postgres server
Can anyone tell me how the searchable email archive on the postgres site
is implemented. Is postgres used as part of the back end ?
Has anyone tried using a postgres based solution for archiving email for
regulatory purposes ?
Jake Costello
---(end of broadcast)--
