[ADMIN] Comparing MySQL and PostgreSQL 2

http://ask.slashdot.org/askslashdot/05/09/05/1514246.shtml?tid=221&tid=4 -- "Adopting the position that you are smarter than an automaticoptimization algorithm is generally a good way to achieve lessperformance, not more" - Tom Lane.

[ADMIN] FW: Libpq - multibyte character support

Title: FW: Libpq - multibyte character support Hi all, My question is does PgSQL libpq functions support multibyte characters...if not then is there a way to provide multibyte data to Postgres using libpq functions. The other question is does Postgres support Chinese charactersif I in

[ADMIN] Windows pgpass Problems..

I have been stuggling all day with the pgpass ability on 8.0 Postgres - on Windows 2000. I have been to the documentation: After reading many threads on similar problems, I just cannot seem to get a batch file to recognize that

Re: [ADMIN] Windows pgpass Problems..

> I have been stuggling all day with the pgpass ability on 8.0 Postgres - on > Windows 2000. I have been to the > documentation: > After reading many threads on similar problems, I just cannot seem to get a > batch file to re

Re: [ADMIN] Windows pgpass Problems..

Right, I found where %APPDATA% was through all the other posts (including yours I believe) - but nevertheless dropping the pgpass.conf into ALL of the %APPDATA% areas - 'All Users', 'postgres' (windows user, just in case), 'emertone' (my machine id), 'Administrator' - none of them seem to take

Re: [ADMIN] Windows pgpass Problems..

Eric, I will be interested to see someone's response to your message, because I am having the same problem (in Windows 2003, version 8.0). I want to use it in a batch file that invokes psql to load a database, etc. without prompting for a password. I have not tried to use wildcards (defeats the pur

Re: [ADMIN] Windows pgpass Problems..

Lane I may have found the problem (or at least a way around it) - through another thread search. The file: C:\Program Files\PostgreSQL\\data\pg_hba.conf ..has general connection info for hitting postgres. Mine looked like: # TYPE DATABASEUSERCIDR-ADDRESS METHOD local a

Re: [ADMIN] Windows pgpass Problems..

I am relatively new to PostgreSQL too, so we are sharing the same boat :-) Will try it, it will get me by a big problem temporarily, but hopefully somebody will answer why the 'recommended way' does not (appear) to work. As it turns out, this would work for me, so long as I copy in another pg_hba.

Re: [ADMIN] Windows pgpass Problems..

I believe the problem is that under Windows there is no such entity as $HOME. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Lane Van Ingen Sent: Tuesday, September 06, 2005 1:55 PM To: Eric Emerton; pgsql-admin@postgresql.org Subject: Re: [ADMIN] Window

Re: [ADMIN] Windows pgpass Problems..

On Tue, Sep 06, 2005 at 11:24:45AM -0400, Eric Emerton wrote: > I have been stuggling all day with the pgpass ability on 8.0 Postgres > - on Windows 2000. I have been to the > documentation: > After reading many threads on similar

[ADMIN] how to change index cluster ratio?

I am using 8.0.3 One problem I found is that even if I specify to create a clustered index by "cluster idx_name on table_name", I still can not tell the optimizer that the index of "idx_name" is a clustered index with "index correlation" value as 1.0 (traced from the cost_index() in costsize.c)

Re: [ADMIN] how to change index cluster ratio?

huaxin zhang <[EMAIL PROTECTED]> writes: > One problem I found is that even if I specify to create a clustered index by > "cluster idx_name on table_name", I still can not tell the optimizer that the > index of "idx_name" is a clustered index with "index correlation" value as 1.0 > (traced from th

Re: [ADMIN] Windows pgpass Problems..

On Tue, 2005-09-06 at 10:24, Eric Emerton wrote: > I have been stuggling all day with the pgpass ability on 8.0 Postgres - on > Windows 2000. I have been to the > documentation: > After reading many threads on similar problems,

[ADMIN] How to determine date / time of last postmaster restart

Please let me know if there is a way to determine when the Postmaster was last restarted? This is for tuning. I have stats_reset_on_server_start turned on, but I don't know when last the Postmaster was started, so I can't determine the period my current system stats cover.

Re: [ADMIN] How to determine date / time of last postmaster restart

adey <[EMAIL PROTECTED]> writes: > Please let me know if there is a way to determine when the Postmaster was > last restarted? The last postmaster start time, or the last database reset? These are not the same if any backends have crashed since the postmaster started. For determining stats lifesp

Re: [ADMIN] FW: Libpq - multibyte character support

CREATE DATABASE name ENCODING = WIN1256 THIS MAY BE THE SOLUTION ALSO YOU CAN PROBE WITH : ALT, LATIN1 TO LATIN9, EUC_CN, EUC_JP,EUCCREATE DATABASE name ENCODING = WIN1256 THIS MAY BE THE SOLUTION ALSO YOU CAN PROBE WITH : ALT, LATIN1 TO LATIN9, EUC_CN, EUC_JP,EUC_KR..

Re: [HACKERS] [ADMIN] How to determine date / time of last postmaster restart

On Tue, Sep 06, 2005 at 08:22:34PM -0400, Tom Lane wrote: > PG 8.1 will have a function to return postmaster start time, but not > database reset time. I wonder if this is misdefined --- if you are > trying to measure database uptime, the last reset would be more > appropriate to track. Is it too

Re: [ADMIN] FW: Libpq - multibyte character support

The problem that I am facing is not with creating the database to support multi bytes. I have a code written in C/C++. I am using libpq functions to do the database operations. But the problem is the libpq functions accept the database queries only in the form of char * . It does not accept