Re: [GENERAL] Slony-I 1.0.4 Released

After takin a swig o' Arrakan spice grog, Gaetano Mendola <[EMAIL PROTECTED]> belched out: > Christopher Browne wrote: > > Oops! Gaetano Mendola <[EMAIL PROTECTED]> was seen spray-painting on a wall: > > > >>Chris Browne wrote: > >> > The Slony-I team is proud to present the 1.0.4 release of t

Re: [GENERAL] ia64 hostname lookup problem

On Friday October 22 2004 5:11, Tom Lane wrote: > "Ed L." <[EMAIL PROTECTED]> writes: > > I've installed both 32-bit and 64-bit executables of 7.4.5 on ia64 > > running HP-UX B.11.23. The 32-bit version works fine and accepts both > > local and remote connections. The 64-bit version, however, rej

Re: [GENERAL] combining two queries?

Title: RE: [GENERAL] combining two queries? Try select a.name,count(*) from xenons as a, viewer_movies as b where a.id = b.viewerid group by a.name order by a.name; -Original Message- From: Mark Harrison [mailto:[EMAIL PROTECTED]] Sent: Friday, October 22, 2004 4:55 PM To: [EMAIL

Re: [GENERAL] Problem with query plan

Cott Lang <[EMAIL PROTECTED]> writes: > Fiddling with the above values, only setting sort_mem absurdly large > easily causes NAN. Ah. I see an overflow case for sort_mem exceeding 1Gb; that's probably what you tickled. I've fixed this in HEAD, but it doesn't seem worth back-patching. If you ca

[GENERAL] combining two queries?

How can I combine these two queries? # select viewerid,count(*) from viewer_movies group by viewerid order by viewerid; viewerid | count --+ 22964835 | 3055 22964836 | 1291 22964837 | 3105 22964838 |199 planb=# select name from xenons where id = 23500637; name

Re: [GENERAL] Problem with query plan

On Fri, 2004-10-22 at 14:19, Tom Lane wrote: > Cott Lang <[EMAIL PROTECTED]> writes: > > sort_mem = 8192 > > random_page_cost = 2 > > effective_cache_size = 3932160 > > effective_cache_size 30Gb ? Seems a tad high ;-) It's a 32GB machine with nothing else running on it except PG, buffers hover a

Re: [GENERAL] index not used?

Scott Marlowe wrote: On Wed, 2004-10-20 at 08:06, Dan Pelleg wrote: I'm trying to access a table with about 120M rows. It's a vertical version of a table with 360 or so columns. The new columns are: original item col, original item row, and the value. I created an index: CREATE INDEX idx on table (

Re: [GENERAL] correct example of a functional index usage?

Tom Lane wrote: Since we don't yet have bitmap combining of indexes... ^^^ Are you trying to tell us something ? :-) Regards Gaetano Mendola ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [GENERAL] ia64 hostname lookup problem

"Ed L." <[EMAIL PROTECTED]> writes: > I've installed both 32-bit and 64-bit executables of 7.4.5 on ia64 running > HP-UX B.11.23. The 32-bit version works fine and accepts both local and > remote connections. The 64-bit version, however, rejects any/all attempts > to connect with the following

[GENERAL] ia64 hostname lookup problem

I've installed both 32-bit and 64-bit executables of 7.4.5 on ia64 running HP-UX B.11.23. The 32-bit version works fine and accepts both local and remote connections. The 64-bit version, however, rejects any/all attempts to connect with the following message: FATAL: no pg_hba.conf entry for

Re: [GENERAL] unexpected field count in D message

"Hicham G. Elmongui" <[EMAIL PROTECTED]> writes: > what does this message mean? libpq is unhappy because the DataRow ('D') message had a field count different from the preceding RowDescription ('T') message. How did you manage that? regards, tom lane

Re: [GENERAL] Two questions from the boss (SQL:2003 && scalability)

On Fri, 22 Oct 2004 14:18:52 -0400, Jan Wieck <[EMAIL PROTECTED]> wrote: > > > That "multiple hosts" sounds that he came across the NDB cluster stuff > that will become available in MySQL someday. Be aware that this new > table handler will to my knowledge NOT support foreign keys. So the > enfor

Re: [GENERAL] Slony-I 1.0.4 Released

Christopher Browne wrote: > Oops! Gaetano Mendola <[EMAIL PROTECTED]> was seen spray-painting on a wall: > >>Chris Browne wrote: >> > The Slony-I team is proud to present the 1.0.4 release of the most >> > advanced replication solution for the most advanced Open Source >> > Database in the world. >

[GENERAL] Slony-I 1.0.5 Released

The Slony-I team is happy to present the 1.0.5 release. The release tarball is available for download http://developer.postgresql.org/~wieck/slony1/download/slony1-1.0.5.tar.gz See the HISTORY-1.0 file for a detailed list of changes. -- let name="cbbrowne" and tld="cbbr

Re: [GENERAL] Problem with query plan

Cott Lang <[EMAIL PROTECTED]> writes: > sort_mem = 8192 > random_page_cost = 2 > effective_cache_size = 3932160 effective_cache_size 30Gb ? Seems a tad high ;-) However, I set up a dummy test case on 7.4.5 and don't see any overflow. regression=# create table z1(f1 char(1253)); CREATE TABLE reg

Re: [GENERAL] Problem with query plan

shared_buffers = 16384 sort_mem = 8192 random_page_cost = 2 effective_cache_size = 3932160 On Fri, 2004-10-22 at 13:32, Tom Lane wrote: > Cott Lang <[EMAIL PROTECTED]> writes: > > Oops, sorry - guess I left that out - 7.4.5. :) > > Hmm ... I can't duplicate any misbehavior here. Are you using >

Re: [Slony1-general] Re: [GENERAL] Slony-I 1.0.4 Released

On Fri, Oct 22, 2004 at 09:36:10AM -0400, Jan Wieck wrote: > wealth. And as long as Afilias is using Slony-I in production, Andrew > Sullivan will not let me do whatever I want if there's a severe problem > nobody else can fix. Or someone around here will, anyway. I might get hit by a wayward

Re: [GENERAL] delayed input

Well, it seems that i have to build the scan operator myself. Even the FunctionScan will make all the function calls and stores the result in a tuuplestore. So, all the delay will be occured only at the first function invocation. --h "Alvaro Herrera" <[EMAIL PROTECTED]> wrote in message news:[E

[GENERAL] unexpected field count in D message

what does this message mean? thanks, --h ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [GENERAL] Problem with query plan

Cott Lang <[EMAIL PROTECTED]> writes: > Oops, sorry - guess I left that out - 7.4.5. :) Hmm ... I can't duplicate any misbehavior here. Are you using nondefault values for any planner parameters? (particularly sort_mem, random_page_cost, effective_cache_size) regards, to

Re: [GENERAL] Problem with query plan

Oops, sorry - guess I left that out - 7.4.5. :) On Fri, 2004-10-22 at 12:28, Tom Lane wrote: > Cott Lang <[EMAIL PROTECTED]> writes: > >-> Sort (cost=nan..nan rows=2023865 width=1257) > > What PG version is this? My recollection is we fixed such a thing quite > some time ago ... > >

Re: [GENERAL] Problem with query plan

Cott Lang <[EMAIL PROTECTED]> writes: >-> Sort (cost=nan..nan rows=2023865 width=1257) What PG version is this? My recollection is we fixed such a thing quite some time ago ... regards, tom lane ---(end of broadcast)-

Re: [GENERAL] PlPERL and shared libraries on Suse

Hi Steve and Tom, Thanks for the tip, I was clearly not reading the error message closely enough. I copied libperl.so into /lib, and now everything works. Many thanks, Eric Steve Atkins wrote: On Fri, Oct 22, 2004 at 12:13:12PM -0400, Eric E wrote: Hi, I have an installation of Postgres 7.4.2 on

[GENERAL] Problem with query plan

I have come up with a simple query that runs horribly depending on the number of columns selected. select order_lines.* from orders, order_lines where orders.merchant_order_id = '11343445' and order_lines.order_id=orders.order_id; merchant_order_id is indexed. order_id is indexed. Tables are an

Re: [Slony1-general] Re: [GENERAL] Slony-I 1.0.4 Released

Wow. First, thanks again for all your efforts, Jan. Second, I'm disappointed to hear the slony author and lead developer is leaving the slony leadership. When is that going to happen? And what does that mean with respect to your future involvement in slony? Ed On Friday October 22 2004 7:

Re: [GENERAL] correct example of a functional index usage?

The site seems to be down Tom. Tom Lane wrote: I don't see any indexable operator there at all. You might care to read http://developer.postgresql.org/docs/postgres/xindex.html which describes the behaviors Postgres indexes have. regards, tom lane -

Re: [GENERAL] Two questions from the boss (SQL:2003 && scalability)

On 10/21/2004 3:40 PM, John Wells wrote: Guys, My boss has been keeping himself busy reading MySQL marketing pubs, and came at me with a few questions this morning regarding PostgreSQL features (we're currently moving to PostgreSQL). While I don't think either are really that important for our situ

Re: [GENERAL] Two questions from the boss (SQL:2003 && scalability)

On Thu, Oct 21, 2004 at 03:40:23PM -0400, John Wells wrote: > Guys, > > My boss has been keeping himself busy reading MySQL marketing pubs, > and came at me with a few questions this morning regarding PostgreSQL > features (we're currently moving to PostgreSQL). I should point out that there's a

[GENERAL] A Simple Question

Greetings: While working with plpgsql and triggers, I've been using TG_NAME to display the trigger name at various points where I need to raise an exception and return a message. I was thinking how nice it would be if I could display the line number as well. Is there a "special" variable that d

Re: [GENERAL] PlPERL and shared libraries on Suse

Eric E <[EMAIL PROTECTED]> writes: > createlang: language installation failed: ERROR: could not load library > "/usr/lib/postgresql/plperl.so": libperl.so: cannot open shared object > file: No such file or directory > The file, however, is there: > # ls -l /usr/lib/postgresql/plperl.so > -rwxr

Re: [GENERAL] PlPERL and shared libraries on Suse

On Fri, Oct 22, 2004 at 12:13:12PM -0400, Eric E wrote: > Hi, >I have an installation of Postgres 7.4.2 on SuSE 9.1. This version > of SuSE comes with a binary for plperl and several other postgres > procedural languages. All the others, including plpgsql install without > a problem, but

Re: [Slony1-general] Re: [GENERAL] Slony-I 1.0.4 Released

On 10/22/2004 11:29 AM, Ed L. wrote: Wow. First, thanks again for all your efforts, Jan. Second, I'm disappointed to hear the slony author and lead developer is leaving the slony leadership. When is that going to happen? And what does that mean with respect to your future involvement in slon

[GENERAL] PlPERL and shared libraries on Suse

Hi, I have an installation of Postgres 7.4.2 on SuSE 9.1. This version of SuSE comes with a binary for plperl and several other postgres procedural languages. All the others, including plpgsql install without a problem, but executing: createlang -u postgres plperl template1 produces the

Re: [GENERAL] correct example of a functional index usage?

Dennis Gearon <[EMAIL PROTECTED]> writes: > But it is possible to use multiple indexes on dates, and that is why the one at the > bottom works, right? No, it is possible to use multiple conditions that are relevant to a single index. A range query like "where x >= lobound and x <= hibound" works

Re: [GENERAL] Slony-I 1.0.4 Released

Sorry folks, the Slony-I team has produced a great product, but the project management (that's mostly me here) sucks big time! Shortly after giving Chris Browne green light for the 1.0.4 announcement we found a way to guard against bug #896. That being a really bad one I decided to stop the 1.0

Re: [GENERAL] correct example of a functional index usage?

But it is possible to use multiple indexes on dates, and that is why the one at the bottom works, right? Would a single index get used for SELECT appointment FROM the_table WHERE 0 <> (date_mask && date_range); Tom Lane wrote: No, an index can be used for one or the other. Since we don't yet ha

Re: [GENERAL] Two questions from the boss (SQL:2003 && scalability)

I've worked with Oracle, Interbase, and Informix. PostgreSQL is the most SQL spec compliant of any of them, whether the spec is 89, 92, or 03. I have not worked with MySQL. Rick

Re: [GENERAL] Row versioning

"Ruediger Herrmann" <[EMAIL PROTECTED]> writes: > Is there any information wether this approach is future proof? [ shrug... ] As much as anything that's not specified by the SQL standard is around here. We have no plans to replace MVCC, and xmin/xmax are a pretty fundamental part of that.

Re: [GENERAL] FKs and deadlocks

Stephan Szabo <[EMAIL PROTECTED]> writes: > On Fri, 22 Oct 2004, Philippe Lang wrote: >> I don't know if anyone has a better idea, but I would like to try taking >> away some FKs in my schema. My problem is that I really don't know which >> one to delete. There are over 40 tables. Are there rules t

Re: [GENERAL] table size/record limit

Great Idea! When I get that far, I will try it. Gaetano Mendola wrote: For partion in some way I don't mean only split it in more tables. You can use some available tools in postgres and continue to see this table as one but implemented behind the scenes with more tables. One usefull and impressiv

Re: [GENERAL] FKs and deadlocks

On Fri, 22 Oct 2004, Philippe Lang wrote: > I have tried to correct that by adding a "SET CONSTRAINTS ALL DEFERRED" > in every trigger and function, hoping it would solve my problem. Maybe > it helped, but it did not solve anything. Note that set constraints all deferred does nothing unless you m

Re: [GENERAL] Row versioning

thanks for your replay. This approach sounds very comfy. As I read the documentation this is kind of a "transaction sequence" or better a "unique transaction id". Am I right with this? So every row inserted or updated within the same transaction is tagged with the same xmin. Is there any informat

[GENERAL] PostgreSQL-related job posting

Guys, I have an opening currently for the following position. If interested, email me at john.wells__replace_this_with_at__timco.aero. Although relo is stated as not covered, I may be able to fight for that given a very qualified candidate. Company:TIMCO Aviation Services Location:

[GENERAL] FKs and deadlocks

Hello, As the amount of simultaneous users of my database grows (25 users sometimes, PGSQL 7.4.5), deadlocks are unfortunately more and more frequent. I guess this is due to the FKs problem with Postgresql. I have tried to correct that by adding a "SET CONSTRAINTS ALL DEFERRED" in every trigger a

Re: [GENERAL] Information about storge engine in PostgreSQL

I really appreciate these type of high-quality anwsers, thank you. Tim > On 10/21/2004 10:27 AM, [EMAIL PROTECTED] wrote: > >> Hello >> >> MySQL has information about several storage engines. MEMORY to handle >> temporary tables, InnoDB to handle transactions and which also can split >> its table

Re: [GENERAL] Is it possible to remove the public schema?

> No problem at all. > It's easy to automate the table linking process. > > I have a table in access that holds - among other things - the internal > and external name of my linked tables, in which database, schema and > server they locate. [snip] Thank you very much for the information. Regards

Re: [GENERAL] table size/record limit

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Dennis Gearon wrote: | Gaetano Mendola wrote: | |> Dennis Gearon wrote: |> |>> I am designing something that may be the size of yahoo, google, ebay, |>> etc. |>> |>> Just ONE many to many table could possibly have the following |>> characteristics: |>>