[SQL] specifying different location for data and wal on fedora core 3 /backup question again

Being new to Linux I am not 100% sure on a few items.   I could find % setenv PGDATA2 /home/postgres/data% initlocation $PGDATA2Creating Postgres database system directory /home/postgres/data Creating Postgres database system directory /home/postgres/data/base   For defining data in a

[SQL] postgres8 install on fedora core 3 (or redhat4 beta AS)

Any help? I got the 8 rpms for fedora and it keeps asking for 7.4 rpm’s, I down load the specific 7.4 stuff and it says already installed?   Joel Fradkin   Wazagua, Inc. 2520 Trailmate Dr Sarasota, Florida 34243 Tel.  941-753-7111 ext 305   [EMAIL PROTECTED] www.wazagua.com

[SQL] Assoclist is still slow and I am not seeing it

Hi, I asked about this before and am still fighting for success; any ideas I tried adding a index on jobtitle.   Explain analyze returns   QUERY PLAN "Merge Join  (cost=53053.05..53652.66 rows=4888 width=113) (actual time=9788.066..11042.584 rows=85694 loops=1)" "  Merge Cond: (""out