[GENERAL] Archiving solution

Hi, Does anybody know any commercial or open source archieving solutions available out there? We need to be able to archieve data/records from certain tables that are more than 1 year old. Thank you in advance. J ---(end of broadcast)--- TIP 2: you

Re: [GENERAL] table clustering brings joy

Quick questions: For big tables with frequent insert, no update, and frequent read (using indexes), will clustering help? what should be done on such table other than regular analyze? comments are appreciated. On 8/16/05, Kevin Murphy <[EMAIL PROTECTED]> wrote: > Greg Stark wrote: > > >All that

[GENERAL] in transaction

Hi, We have applications that sits on top of Java application server. Our code is written in Java, sitting on top of Jboss with Hibernate, and we use JDBC driver pg74.215.jdbc2ee.jar. We have observed a number of in transaction on pg_stat_activity. I am wondering if there's command/view/system ta

[GENERAL] migrating from mysql

Hi everyone, I am new to postgresql. I am planning to migrate our current database (mysql) to posgresql. I am currently having difficulties dealing with the order of the tables that is created. Here is what I do: 1. I use myqsldump to get the schema and data. 2. I use my2pg and a java utility I cre

Re: [GENERAL] What's a good default encoding?

I am wondering if somebody here can tell me the difference between UTF-8 and SQL-ASCII, whether there are any benefits of converting SQL-ASCII to UTF-8? If so, under what circumstances do we want to convert to UTF-8? Thanks, On 3/15/06, Michael Schmidt <[EMAIL PROTECTED]> wrote: Perhaps oth