[GENERAL] The Best Postgresql Load Balancing Solution

Hi,i was searching for a load balancing solution for postgres, I found some ready to use software like PGCluster, Slony, pgpool and others.It would really be nice if someone knows which one is the best taking in consideration that i have an already running application that i need to load balance.I

Re: [GENERAL] PostgreSQL slammed by PHP creator

On 09/14/06 21:32, AgentM wrote: > > On Sep 14, 2006, at 21:25 , Bruce Momjian wrote: > >> >> I am not going to ask how you got to 135MPH. > > Obviously he was running MySQL under the hood. No wonder he spun out and crashed into a telephone poll... -- Ron Johnson, Jr. Jefferson LA USA Is "c

Re: [GENERAL] PostgreSQL slammed by PHP creator

On Thu, 14 Sep 2006, AgentM wrote: Obviously he was running MySQL under the hood. Ta-da! We have a winner! Rich -- Richard B. Shepard, Ph.D. |The Environmental Permitting Applied Ecosystem Services, Inc.(TM)|Accelerator Voi

Re: [GENERAL] PostgreSQL slammed by PHP creator

On Sep 14, 2006, at 21:25 , Bruce Momjian wrote: I am not going to ask how you got to 135MPH. Obviously he was running MySQL under the hood. -M ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archive

Re: [GENERAL] PostgreSQL slammed by PHP creator

bank :) Are we talking about this one? http://www.musclecarclub.com/musclecars/plymouth-cuda/plymouth-cuda.shtml Note that this was a very long time ago :) I hope it wasn't on 1966 ... I am not going to ask how you got to 135MPH. Oh that is easy, you just press on the gas and watch the car

Re: [GENERAL] PostgreSQL slammed by PHP creator

Joshua D. Drake wrote: I can top that :). I hit a telephone pole at 135MPH in a 66 Cuda :) If it hadn't been for the gravel around that corner, I would have beat the other car too. ' (a tear for your 66 cuda...) Hell I cried more then a tear. The cop felt so bad for me, he didn't even tick

Re: [GENERAL] PostgreSQL slammed by PHP creator

Alvaro Herrera wrote: Joshua D. Drake wrote: I can top that :). I hit a telephone pole at 135MPH in a 66 Cuda :) If it hadn't been for the gravel around that corner, I would have beat the other car too. ' (a tear for your 66 cuda...) Hell I cried more then a tear. The cop felt so bad for me, h

Re: [GENERAL] PostgreSQL slammed by PHP creator

Bruce Momjian wrote: Alvaro Herrera wrote: Joshua D. Drake wrote: I can top that :). I hit a telephone pole at 135MPH in a 66 Cuda :) If it hadn't been for the gravel around that corner, I would have beat the other car too. ' (a tear for your 66 cuda...) Hell I cried more then a tear. The cop

Re: [GENERAL] PostgreSQL slammed by PHP creator

Alvaro Herrera wrote: > Joshua D. Drake wrote: > > >> > > >>I can top that :). I hit a telephone pole at 135MPH in a 66 Cuda :) > > >>If it hadn't been for the gravel around that corner, I would have beat > > >>the other car too. > > > > > >' (a tear for your 66 cuda...) > > > > Hell I cried more

Re: [GENERAL] PostgreSQL slammed by PHP creator

Joshua D. Drake wrote: > >> > >>I can top that :). I hit a telephone pole at 135MPH in a 66 Cuda :) > >>If it hadn't been for the gravel around that corner, I would have beat > >>the other car too. > > > >' (a tear for your 66 cuda...) > > Hell I cried more then a tear. The cop felt so bad for me

Re: [GENERAL] PostgreSQL slammed by PHP creator

I can top that :). I hit a telephone pole at 135MPH in a 66 Cuda :) If it hadn't been for the gravel around that corner, I would have beat the other car too. ' (a tear for your 66 cuda...) Hell I cried more then a tear. The cop felt so bad for me, he didn't even ticket me... All white, red

Re: [GENERAL] PostgreSQL slammed by PHP creator

Joshua D. Drake wrote: [EMAIL PROTECTED] wrote: [EMAIL PROTECTED] wrote on 15/09/2006 04:40:04 a.m.: I wasn't able to find anything the "article" worth discussing. If you give up A, C, I, and D, of course you get better performance- just like you can get better performance from a wheel-less

Re: [GENERAL] Initializing Datums for use with SPI_execute_plan

On 2006-09-14, "Jack Orenstein" <[EMAIL PROTECTED]> wrote: > I don't think I explained myself clearly. I have a C string (char*, > terminating zero) and a byte array (char*, possibly containing zeros, > and I know the length). I want to obtain Datums wrapping these values > that will be used to bin

Re: [GENERAL] PostgreSQL slammed by PHP creator

On Thu, 2006-09-14 at 11:40, Joshua D. Drake wrote: > > I wasn't able to find anything the "article" worth discussing. If you > > give up A, C, I, and D, of course you get better performance- just like > > you can get better performance from a wheel-less Yugo if you slide it > > down a luge trac

Re: [GENERAL] PostgreSQL slammed by PHP creator

Brandon Aiken wrote: And yet this man is smart enough not to run MySQL on Windows. Methinks this says something Heh.. Joshua D. Drake -- Brandon Aiken CS/IT Systems Engineer -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Joshua D. Drake Sent:

Re: [GENERAL] Initializing Datums for use with SPI_execute_plan

On 9/13/06, Martijn van Oosterhout wrote: On Tue, Sep 12, 2006 at 09:57:33PM -0400, Jack Orenstein wrote: > ... > int, bigint: From looking at postgres.h, I realize that Datum is an > unsigned long. I'm guessing that I should just be able to assign Datums > carrying ints or bigints, e.g. using I

[GENERAL] Feature request (was psql: absolutes and toggles)

I would like the ability to absolutely set parameters/settings in psql so that our psql scripts could generate predictable output absent a known or controllable initial state. Original discussion at bottom of message. One alternate and easier approach I've thought of is to simply add something aki

Re: [GENERAL] PostgreSQL slammed by PHP creator

And yet this man is smart enough not to run MySQL on Windows. Methinks this says something -- Brandon Aiken CS/IT Systems Engineer -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Joshua D. Drake Sent: Thursday, September 14, 2006 5:16 PM To: [EMAIL P

Re: [GENERAL] PostgreSQL slammed by PHP creator

[EMAIL PROTECTED] wrote: [EMAIL PROTECTED] wrote on 15/09/2006 04:40:04 a.m.: I wasn't able to find anything the "article" worth discussing. If you give up A, C, I, and D, of course you get better performance- just like you can get better performance from a wheel-less Yugo if you slide it do

Re: [GENERAL] Is it possible to have multiple names for a column?

On Thu, Sep 14, 2006 at 12:18:05PM -0700, [EMAIL PROTECTED] wrote: > We have a need to rename some columns, but since we can't update both > the database and the programs instantly, we'd like to temporarily > assign both names to the same column while the updates are in > progress. Something like

[GENERAL] Sun Java Studio Creator and PostgreSQL

I have some troubles getting Sun Java Studio Creator & Sun Java Application Server to work with PostgreSQL. Trying different syntaxes for the SQL statement (schema or no schema) in the session bean I get either the error: "No columns in table: pmh.tablename" or "Cannot change transaction isola

Re: [GENERAL] Is it possible to have multiple names for a column?

On Thu, 2006-09-14 at 14:18, [EMAIL PROTECTED] wrote: > We have a need to rename some columns, but since we can't update both > the database and the programs instantly, we'd like to temporarily > assign both names to the same column while the updates are in > progress. Something like this would be

Re: [GENERAL] Is it possible to have multiple names for a column?

[EMAIL PROTECTED] writes: > I am pretty certain no such SQL command exists. But is it possible to > do something sneaky to the internal tables so that two names point to > the same columnand everything just works? No ... at least not for usefully large values of "work". You might be able to do s

[GENERAL] Is it possible to have multiple names for a column?

We have a need to rename some columns, but since we can't update both the database and the programs instantly, we'd like to temporarily assign both names to the same column while the updates are in progress. Something like this would be super nifty :-) ALTER TABLE howdy_doody ADD NAME xyzzy T

Re: [GENERAL] PostgreSQL slammed by PHP creator

* Arturo Perez ([EMAIL PROTECTED]) wrote: > Any response to this: > http://www.internetnews.com/dev-news/article.php/3631831 Turn fsync off and try again. Don't expect your data to stay consistant tho. Enjoy, Stephen signature.asc Description: Digital signature

Re: [GENERAL] initdb: invalid locale name "sv_SE.ISO-8859-1"

Thanks for the advice, I tried to install the "language-packs" that ubuntu supports. I can no initialize a se_SV.utf8 cluster, but it seems there is no support form latin1. Best whishes /Ragnar ---(end of broadcast)--- TIP 6: explain analyze is yo

Re: [GENERAL] Majordomo drops multi-line Subject:

Michelle Konzack wrote: > Hello Marc, > > Am 2006-09-09 12:50:36, schrieb Marc G. Fournier: > >> And I missed this one from Joshua ... but, we aren't running Majordomo >> from GreatCircle, we are running Majordomo2 (http://www.mj2.org) which is >> very much being actively support ... > > I hav

Re: [GENERAL] Client Connections

Curtis Scheer wrote: Is there a setting to limit the number of database connections per IP address or client? No but you can limit per database as a whole. Joshua D. Drake Thanks, Curtis -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564

Re: [GENERAL] Majordomo drops multi-line Subject:

Hello Marc, Am 2006-09-09 12:50:36, schrieb Marc G. Fournier: > And I missed this one from Joshua ... but, we aren't running Majordomo > from GreatCircle, we are running Majordomo2 (http://www.mj2.org) which is > very much being actively support ... I have seen... > Majordomo2 support a nomai

[GENERAL] OK, this is a Test für a Subject containing one non ASCII character ans some more like éáóèàòôç [WAS: Re: [GENERAL] This is a Reply to the message "Re: Majordomo drops multi-line Subject

Hi Alvaro, This is a second test with some non US-ACII characters... Since I am in France, I have never seen broken Subject lines. Greetings Michelle Konzack Systemadministrator Tamay Dogan Network Debian GNU/Linux Consultant Am 2006-09-09 12:30:25, schrieb Alvaro Herrera: > I

Re: [GENERAL] PostgreSQL slammed by PHP creator

I wasn't able to find anything the "article" worth discussing. If you give up A, C, I, and D, of course you get better performance- just like you can get better performance from a wheel-less Yugo if you slide it down a luge track. I don't think a Yugo would give you better performance no mat

Re: [GENERAL] PostgreSQL slammed by PHP creator

Alvaro Herrera wrote: Joshua D. Drake wrote: However, he does carry some umpf in certain circles. Perhaps we should prove him wrong? I take it you mean "oomph"? Yeah probably :) Main Entry: oomph Pronunciation: 'um(p)f Function: noun Etymology: imitative of a sound made under exertion 1

Re: [GENERAL] PostgreSQL slammed by PHP creator

Joshua D. Drake wrote: > However, he does carry some umpf in certain circles. Perhaps we should > prove him wrong? I take it you mean "oomph"? Main Entry: oomph Pronunciation: 'um(p)f Function: noun Etymology: imitative of a sound made under exertion 1 : personal charm or magnetism : GLAMOUR 2

Re: [GENERAL] PostgreSQL slammed by PHP creator

Arturo Perez wrote: Hi all, Any response to this: http://www.internetnews.com/dev-news/article.php/3631831 From the FA: One performance enhancement that Lerdorf suggested based on code analysis was to use MySQL instead of PostgreSQL for the database. "If you can fit your problem into what My

Re: [GENERAL] PostgreSQL slammed by PHP creator

AgentM wrote: On Sep 14, 2006, at 11:27 , Arturo Perez wrote: One performance enhancement that Lerdorf suggested based on code analysis was to use MySQL instead of PostgreSQL for the database. ...If you give up A, C, I, and D, of course you get better performance- just like you can ge

Re: [GENERAL] Client Connections

On Thu, Sep 14, 2006 at 10:59:09AM -0500, Curtis Scheer wrote: > Is there a setting to limit the number of database connections per IP > address or client? 8.1 has per-database and per-user connection limits; see the CONNECTION LIMIT option of {CREATE,ALTER} {DATABASE,ROLE}. http://www.postgresql

Re: [GENERAL] PostgreSQL slammed by PHP creator

Arturo Perez wrote: Any response to this: http://www.internetnews.com/dev-news/article.php/3631831 Oh please! Can we skip this one? Maybe on the advocacy groups, not on [GENERAL], pleze! thanks, bkw ---(end of broadcast)--- TIP 6: explain a

Re: [GENERAL] PostgreSQL slammed by PHP creator

On Sep 14, 2006, at 11:27 , Arturo Perez wrote: Hi all, Any response to this: http://www.internetnews.com/dev-news/article.php/3631831 From the FA: One performance enhancement that Lerdorf suggested based on code analysis was to use MySQL instead of PostgreSQL for the database. "If you c

[GENERAL] Client Connections

Is there a setting to limit the number of database connections per IP address or client?   Thanks,   Curtis

[GENERAL] pgAdmin III v1.6 Beta 1 Released

I'm pleased to announce the first beta version of pgAdmin III v1.6.0 is available for download in Source, Windows, Slackware and Mac OSX formats from: http://www.pgadmin.org/download/ This is a beta version and may contain bugs - please test at your own risk and report any bugs found to [EMAIL PR

Re: [GENERAL] Superuser lost access to particular database

Francisco Reyes <[EMAIL PROTECTED]> writes: > Going to try the FreeBSD lists to see why and when a process would not > show up in ktrace. Specially one using 90% cpu. That's not hard: it's in a loop that doesn't include any kernel calls. regards, tom lane ---

Re: [GENERAL] When to reload and when to restart?

Francisco Reyes <[EMAIL PROTECTED]> writes: > Is there a list anywyere of what config changes take effect after a reload > and which after a restart? These settings require a postmaster restart, nothing else does: select name from pg_settings where context = 'postmaster';

Re: [GENERAL] Running PostgreSQL in a Xen DomU?

My database needs are probably less than yours, but I've had zero issues running postgres inside a domU. I'm not using SAN, but instead DRBD to replicate data at the block level between dom0s. I haven't tried migrating the domU from one machine to another without rebooting it, but the shutd

[GENERAL] PostgreSQL slammed by PHP creator

Title: PostgreSQL slammed by PHP creator Hi all, Any response to this: http://www.internetnews.com/dev-news/article.php/3631831 From the FA: One performance enhancement that Lerdorf suggested based on code analysis was to use MySQL instead of PostgreSQL for the database. "If you can

[GENERAL] Optimising a query requiring seqscans=0

Hi, We recently upgraded our trac backend from sqlite to postgres, and I decided to have a little fun and write some reports that delve into trac's subversion cache, and got stuck with a query optimisation problem. Table revision contains 2800+ rows Table node_change contains 37+. rev is a '

Re: [GENERAL] Superuser lost access to particular database

Tom Lane writes: Nothing happens when I try to run the query. So pg_dump seems off the hook. Can you run the query, attach to the backend with gdb, and see what it's doing? Tried to set level debug5 to see if any extra output appeared in log. Nothing. Going to read up on gdb.. tried ktra

[GENERAL] When to reload and when to restart?

Is there a list anywyere of what config changes take effect after a reload and which after a restart? Reading over a number of settings to optimize performance, but would like to know what settings require restart.. other than trying to use show to see if the change took effect. Can all vari

Re: [GENERAL] Running PostgreSQL in a Xen DomU?

What I'm not sure of: - Maybe it's better to run PGSQL in Dom0, on 2 different Xen units that are beefed up, with a few lighter DomU guest OSs running in the background. Some sort of heartbeat software that allows the 2 Xen units to grab the PGSQL's IP address as needed. PostgreSQL perfor

Re: [GENERAL] Question about timestamp with time zone

"Jan van der Weijde" <[EMAIL PROTECTED]> writes: > When I insert a time stamp value '1903-08-07 00:00:00+02' into a table > and next select it again using psql I get '1903-08-06 22:19:32+00:19'. > I'm located in The Netherlands and before 1940 there was a so called > Amsterdam Time that is UTC + 20

[GENERAL] Question about timestamp with time zone

Hi All,   I have an issue with timestamp with time zone I don't understand.   When I insert a time stamp value '1903-08-07 00:00:00+02' into a table and next select it again using psql I get '1903-08-06 22:19:32+00:19'. I'm located in The Netherlands and before 1940 there was a so called Am

Re: [GENERAL] Inherited tables vs UNION ALL views

Florian Weimer <[EMAIL PROTECTED]> writes: > I'm going to create a (manually) partioned table and wonder whether I > should use inherited tables or an explicitly created view using UNION > ALL. Constraint exclusion is not important for this application > (major updates will directly target the ind

Re: [GENERAL] remote duplicate rows

A. Kretschmer wrote: am Wed, dem 13.09.2006, um 15:46:58 -0700 mailte Junkone folgendes: hI i have a bad situation that i did not have primary key. so i have a table like this colname1colname2 1 apple 1 apple 2

Re: [GENERAL] remote duplicate rows

Dunno about quickly, but I usually do something like this (before slapping myself in the face for getting into that state): CREATE TABLE tn_backup AS SELECT DISTINCT * FROM tn; TRUNCATE TABLE tn; INSERT INTO tn VALUES SELECT * from tn_backup; (Where "tn" is the table name) May not be the best w

[GENERAL] Inherited tables vs UNION ALL views

I'm going to create a (manually) partioned table and wonder whether I should use inherited tables or an explicitly created view using UNION ALL. Constraint exclusion is not important for this application (major updates will directly target the individual tables). After these considerations, is th

[GENERAL] Running PostgreSQL in a Xen DomU?

We're slowly trying to move away from hardware dependence for our servers and it looks like Xen is the path. Our primary goal is that if a particular server fails, we can simply migrate the guest OSs to another Xen node and the users will not experience any downtime. Plus it should allow us t

Re: [GENERAL] remote duplicate rows

If you have a primary key value (or OID?) then you can delete the duplicates in situ using something like (untested) -- should work if never more than 1 duplicate row for colname1, colname2 delete from table where pk_value in ( select min(pk_value) from table group by colname1, colname2 having

Re: [GENERAL] select unique items in db

a schreef: this doesnt work SELECT DISTINCT on link *, rank(ts_vec, to_tsquery('default', $qtxt)) FROM feed_entry WHERE ts_vec @@ to_tsquery('default', $qtxt) ORDER BY rank(ts_vec, to_tsquery('default', $qtxt)) DESC LIMIT 5 OFFSET 0 can you tell me how to get the DISTINCT elements in LINK t