[GENERAL] Optimal database table optimization method

2010-03-04 Thread Roger Tannous
? Will there be a necessary trade-off between speed on select and speed of delete? Is partitioning the only solution ? What are good strategies for partitioning such table? I'm using a PostgreSQL 8.4 database. Best Regards, Roger Tannous.

[GENERAL] pgsql with UTF-8 on Windows OS

2005-09-03 Thread Roger Tannous
Is there a way to set the cmd on Windows XP to use UTF-8 while using pgsql.exe ? Regards, Roger Tannous. __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ---(end