[ADMIN] ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list

The Query needs to have the distinct clause in the select statement and the UPPER clause in the order by clause. eg. select distinct id, type from user_list order by UPPER(type) Please let me know if there is any solution to this issue thanks in advance. -- Best, Gourish Singbal

[ADMIN] Log to Syslog or rotatelogs? Advice Please

Postgres 7.3.9 on RH Linux... Setting up new production server- Is it better to send the postmaster log to Syslog or to rotatelogs? TIA, david ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [ADMIN] ERROR: for SELECT DISTINCT, ORDER BY expressions must

On Mon, 14 Mar 2005, Gourish Singbal wrote: The Query needs to have the distinct clause in the select statement and the UPPER clause in the order by clause. eg. select distinct id, type from user_list order by UPPER(type) Please let me know if there is any solution to this issue thanks in

Re: [ADMIN] Performance Question

I think you need to provide more information to get any help with your setup. For one thing, why are you restarting? Are you restarting the server? Postgres? In general, there should be no need to restart either. Next, what do you mean by broken bad after a full vacuum? -tfo -- Thomas F.

Re: [ADMIN] Performance Question

It doesn't make all that much more sense. I'd keep posting to the lists to let other people continue to take a crack at it. Is the system dedicated entirely to postgres? Are you VACUUMing? What kinds of operations are being performed and how much data is in the database? -tfo -- Thomas F.

Re: [ADMIN] Performance Question

Well, there's always the dbsize module in contrib to check actual size on disk. I was thinking more in terms of approximate numbers of tables and rows in those tables. -tfo -- Thomas F. O'Connell Co-Founder, Information Architect Sitening, LLC http://www.sitening.com/ 110 30th Avenue North,

Re: [ADMIN] Performance Question

I'm wondering if long running transacations might be the cause (you'll likely want to do this while perfomance is suffering). Have a look at pg_stat_activity and see if there are any long running transacations (or any idle transactions). I'd also be curious to see the output of the following:

Re: [ADMIN] Log to Syslog or rotatelogs? Advice Please

On Mon, 2005-03-14 at 08:37, David Wagoner wrote: Postgres 7.3.9 on RH Linux... Setting up new production server- Is it better to send the postmaster log to Syslog or to rotatelogs? That really depends more on your production environment than any thing else. I use apache's rotatelogs

[ADMIN] Performance problem...

Hello... Our company is going to change SQL engine from MySQL to PSQL. Of course some performance problems occured. Our server is Dual Xeon 3.0GHz + 8GB RAM + RAID1(software - two 146GB SCSI 15k) for sql data + RAID1(software - two 146GB SCSI 15k) for pg_xlog. Postgres.conf parameters are as

Re: [ADMIN] Performance problem...

On Mon, 2005-03-14 at 12:03, Marcin Giedz wrote: Hello... Our company is going to change SQL engine from MySQL to PSQL. Of course some performance problems occured. Our server is Dual Xeon 3.0GHz + 8GB RAM + RAID1(software - two 146GB SCSI 15k) for sql data + RAID1(software - two 146GB

Re: [ADMIN] How can I recreate the template0 database?

On Mon, Mar 14, 2005 at 09:59:14AM -0600, Scott Marlowe wrote: On Wed, 2005-03-09 at 01:32, Eduardo Mambrilla Martínez wrote: I made a mistake, I droped the template0 database... How can I recreate it? Do you still have template1? If so, connect in single user mode, enter: postgres

Re: [ADMIN] Performance Question

Hi Thomas, The DB has 134 tables, sizes vary, one of the most used and thus biggest problems currently have around 3,000,000 records in, with 15 fields, around 15000 records per day added. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Thomas