[PERFORM] started Data Warehousing

Hello people! I have a question, I am going to begin a project for the University in the area of Data Warehousing and I want to use postgres. Do you have some recommendation to me? Thanks!! Greetings, Pablo ---(end of broadcast)--- TIP 3: if

Re: [PERFORM] [ADMIN] syslog slowing the database?

Not an option I'm afraid. PostgreSQL just jams and stops logging after the first rotation... Are you using a copy truncate method to rotate the logs? In RedHat add the keyword COPYTRUCATE to your /etc/logrotate.d/syslog file. Sincerely, Joshua D. Drake I know some people use this in

Re: [PERFORM] started Data Warehousing

Pablo Marrero wrote: Hello people! I have a question, I am going to begin a project for the University in the area of Data Warehousing and I want to use postgres. Do you have some recommendation to me? Regarding what? Do you have an specific questions? Sincerely, Joshua D. Drake Thanks!!

Re: [PERFORM] compiling 7.4.1 on Solaris 9

On Wed, Mar 10, 2004 at 11:07:28AM -0500, Andrew Sullivan wrote: At work, we have been doing a number of tests on 7.4. The performance is such an improvement over 7.2 that the QA folks thought there must be something wrong. So I suppose the defaults are ok. I know, I know, replying to

[PERFORM] Impact of varchar/text in use of indexes

Hi. I have two existing tables, A and B. A has a 'varchar(1000)' field and B has a 'text' field, each with btree indexes defined. When I do a join between these, on this field, it seems to a hash join, as opposed to using the indexes, as I might expect (I'm no postgres expert, btw). My

Re: [PERFORM] Impact of varchar/text in use of indexes

Mike Moran [EMAIL PROTECTED] writes: Hi. I have two existing tables, A and B. A has a 'varchar(1000)' field and B has a 'text' field, each with btree indexes defined. When I do a join between these, on this field, it seems to a hash join, as opposed to using the indexes, as I might expect

[PERFORM] Sorting when LEFT JOINING to 2 same tables, even aliased.

Hello to everybody. I ask your help for a severe problem when doing a query that LEFT JOINs one table to another ON a field, and then LEFT JOINs again to another instance of a table ON another field which stores the same entity, but with different meaning. I include 3 EXPLAIN ANALYZEs: * The

Re: [PERFORM] Sorting when LEFT JOINING to 2 same tables, even

On Thu, 11 Mar 2004, Octavio Alvarez wrote: Hello to everybody. I ask your help for a severe problem when doing a query that LEFT JOINs one table to another ON a field, and then LEFT JOINs again to another instance of a table ON another field which stores the same entity, but with