Re: [GENERAL] Yet Another COUNT(*)...WHERE...question

"Scott Marlowe" wrote: >When I go to amazon.com I only ever get three pages of results. ever. > Because they know that returning 190 pages is not that useful, as >hardly anyone is going to wander through that many pages. > >Google, you'll notice says "Results 1 - 10 of about 5,610,000 for >blacks

Re: [GENERAL] Yet Another COUNT(*)...WHERE...question

Decibel! wrote: >On Thu, Aug 16, 2007 at 12:12:03PM +0200, Rainer Bauer wrote: >> "Scott Marlowe" wrote: >> >> >When I go to amazon.com I only ever get three pages of results. ever. >> > Because they know that returning 190 pages is not that usef

Re: [GENERAL] Yet Another COUNT(*)...WHERE...question

"Trevor Talbot" wrote: >On 8/16/07, Rainer Bauer <[EMAIL PROTECTED]> wrote: > >> >> But if you go to eBay, they always give you an accurate count. Even if >> >> the no. >> >> of items found is pretty large (example: <http://search.eb

Re: [GENERAL] Yet Another COUNT(*)...WHERE...question

Gregory Stark wrote: >"Rainer Bauer" <[EMAIL PROTECTED]> writes: > >> Anyway, what Phoenix is trying to say is that 2 queries are required: One to >> get the total count and one to get the tuples for the current page. I reckon >> it would help, if the q

Re: [GENERAL] Yet Another COUNT(*)...WHERE...question

Martijn van Oosterhout wrote: >On Thu, Aug 16, 2007 at 01:09:32PM +0200, Rainer Bauer wrote: >> Anyway, what Phoenix is trying to say is that 2 queries are required: One to >> get the total count and one to get the tuples for the current page. I reckon >> it would help, if th

Re: [GENERAL] Yet Another COUNT(*)...WHERE...question

Bill Moran wrote: >> Consider this query with multiple WHERE conditions: >> >>

Re: [GENERAL] Yet Another COUNT(*)...WHERE...question

Tom Lane wrote: >Rainer Bauer <[EMAIL PROTECTED]> writes: >> My point is that whatever search criterias are involved and how many items >> are found eBay always returns the *accurate* number of items found. > >And exactly how do you know that that's true? 5 ye

Re: [GENERAL] Yet Another COUNT(*)...WHERE...question

"Trevor Talbot" wrote: >On 8/16/07, Rainer Bauer <[EMAIL PROTECTED]> wrote: > >> My point is that whatever search criterias are involved and how many items >> are found eBay always returns the *accurate* number of items found. >> >> Before this dri

Re: [GENERAL] Yet Another COUNT(*)...WHERE...question

"Scott Marlowe" wrote: >FYI, I went to the ebay page you posted, which listed something like >98011 pages, and asked for page 96000. It searched for about a minute >and timed out with the error message > >There was a problem executing your request. Please try again. > >Tried it again, twice, abou

Re: [GENERAL] Using oid as pkey

"D. Dante Lorenso" wrote: >Using a brain-dead sample table that looks like this: > > CREATE table some_table ( > col0 SERIAL, > col1 VARCHAR, > col2 VARCHAR > ); > >I want to do something like this: > > INSERT INTO some_table (col1, col2)

Re: [GENERAL] Removing pollution from log files

Andrew Sullivan wrote: >On Mon, Aug 27, 2007 at 02:00:02PM +0300, Andrus wrote: >> Postgres log files are polluted with messages >> >> 2007-08-27 06:10:38 WARNING: nonstandard use of \\ in a string literal at >> character 190 >> 2007-08-27 06:10:38 HINT: Use the escape string syntax for backsl

Re: [GENERAL] Removing pollution from log files

Andrus wrote: >> Apart from that: there was a bug in the ODBC driver prior 08.02.0402 which >> resulted in this error message whenever binary data of type >> SQL_LONGVARBINARY >> was send. > >Where is 0402 driver ? The snapshot drivers can be found here:

Re: [GENERAL] Cannot install under Windows Vista

tkdchen wrote: >I install PostgreSQL under Windows Vista, but the MSI failed. It told >me that it has no right to create postgres user account. I don't know >why. I just run the MSI package with an Administrator account. Please >help me to solve this problem. Sounds like the UAC (User Access Cont

Re: [GENERAL] PostgreSQL Storage: Sorted by Primary Key?

michi wrote: >Does PostgreSQL store records sorted by primary key? Only after you cluster the table: Rainer ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [GENERAL] 8.2.3: Server crashes on Windows using Eclipse/Junit

"Magnus Hagander" wrote: >> - Max_connections is set to 500. I did that originally because I kept >> seeing a message about no connection available and I thought it was >> because I was not allocating enough connections. My machine has 2GB of RAM. > >There's your problem. 500 is way above what the

Re: [GENERAL] 8.2.3: Server crashes on Windows using Eclipse/Junit

"Trevor Talbot" wrote: >On 10/20/07, Rainer Bauer <[EMAIL PROTECTED]> wrote: >> "Magnus Hagander" wrote: >> >> >> - Max_connections is set to 500. I did that originally because I kept >> >> seeing a message about no connection

Re: [GENERAL] 8.2.3: Server crashes on Windows using Eclipse/Junit

I wrote: >You are right. I just did a quick test and depending on the handle type these >limits are quite high. I could create 5 millions events or 4 millions >semaphores or 3,5 millions mutexes before the system returned error 1816 >ERROR_NOT_ENOUGH_QUOTA "Not enough quota is available to process

Re: [GENERAL] 8.2.3: Server crashes on Windows using Eclipse/Junit

Shelby Cain wrote: >--- Trevor Talbot <[EMAIL PROTECTED]> wrote: > >> On 10/20/07, Shelby Cain <[EMAIL PROTECTED]> wrote: >> >> > I'd personally vote for a lower warning limit like 175 as I can >> > consistently crash Postgresql on Windows system right around the >> 200th >> > connection. >> >>

Fwd: Re[2]: [GENERAL] 8.2.3: Server crashes on Windows using Eclipse/Junit

I wrote > Anyway, the problem are the no. of semaphores created by Postgres: > Every backend creates at least 4* semaphores. Sorry, this must read semaphores, not 4 times. Rainer ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner

Re: [GENERAL] 8.2.3: Server crashes on Windows using Eclipse/Junit

Hello Trevor, Sunday, October 21, 2007, 12:15:25 AM, you wrote: TT> On 10/20/07, Rainer Bauer <[EMAIL PROTECTED]> wrote: >> I could reproduce this here: >> >> Server closed the connection unexpectedly >> This probaly means the server terminated abnormally befo

Re: [GENERAL] 8.2.3: Server crashes on Windows using Eclipse/Junit

Magnus Hagander wrote: >Trevor Talbot wrote: >> On 10/20/07, Rainer Bauer <[EMAIL PROTECTED]> wrote: >> >>> Anyway, the problem are the no. of semaphores created by Postgres: >>> Every backend creates at least 4* semaphores. Just >>> increase to

Re: [GENERAL] 8.2.3: Server crashes on Windows using Eclipse/Junit

Magnus Hagander schrieb: >On Sun, Oct 21, 2007 at 09:43:27PM +0200, Rainer Bauer wrote: >> Magnus Hagander wrote: >> >> >Trevor Talbot wrote: >> >> On 10/20/07, Rainer Bauer <[EMAIL PROTECTED]> wrote: >> >> >> >>> Anyway, th

Re: [GENERAL] 8.2.3: Server crashes on Windows using Eclipse/Junit

Dave Page wrote: >So, we seem to be hitting two limits here - the desktop heap, and >something else which is cluster-specific. Investigation continues... I will make these tests tonight or tomorrow morning and will let you know. Rainer ---(end of broadcast)--

Re: [GENERAL] 8.2.3: Server crashes on Windows using Eclipse/Junit

"Trevor Talbot" wrote: >I wrote: > >[ desktop heap usage ] > >> It could be that there's a significant difference between XP and 2003 >> in how that's handled though. I do have an XP SP2 machine here with >> 512MB RAM, and I'll try tests on it as soon as I can free up what it's >> currently occup

Re: [GENERAL] 8.2.3: Server crashes on Windows using Eclipse/Junit

Dave Page wrote: >Magnus Hagander wrote: >> Rainer Bauer wrote: >>> After increasing the session heap size in the registry from 512KB to 1024KB >>> the no. of connections was roughly doubled. So this might be a solution for >>> people running out of Desktop

Re: [GENERAL] 8.2.3: Server crashes on Windows using Eclipse/Junit

"Dave Page" wrote: >> --- Original Message --- >> From: Rainer Bauer <[EMAIL PROTECTED]> >> To: pgsql-general@postgresql.org >> Sent: 26/10/07, 18:09:26 >> Subject: Re: [GENERAL] 8.2.3: Server crashes on Windows using Eclipse/Junit >>

Re: [GENERAL] Copy the database..

Abandoned wrote: >I tryed pg_dump but it is very slowly. Are there any faster way to >copy database? Actually, I was looking for something along the same line. I often want to test some functionality in my program based on the same dataset. However, dump/restore takes too long to be of any use.

Re: [GENERAL] Copy the database..

Tom Lane wrote: >Rainer Bauer <[EMAIL PROTECTED]> writes: >> Wouldn't it be possible to copy the database folder and somehow instruct the >> postmaster to include the copied data after a restart? > >See CREATE DATABASE's TEMPLATE option. It's a bit c

Re: [GENERAL] Npsql is much faster than ODBC ?

Alvaro Herrera wrote: >FYI there's another Postgres ODBC driver that is said to have better >performance. > >https://projects.commandprompt.com/public/odbcng > >(Yes, my company maintains it) psqlodbc is licenced under LGPL, but ODBCng uses the GPL. That means that commercial software cannot use

Re: [GENERAL] Npsql is much faster than ODBC ?

"Joshua D. Drake" wrote: >> psqlodbc is licenced under LGPL, but ODBCng uses the GPL. >> >> That means that commercial software cannot use the ODBCng driver. Are >> there any plans to release it under LGPL licence? > >The only time this would be an issue is if you tried to embed the >driver. Othe

Re: [GENERAL] Npsql is much faster than ODBC ?

Alvaro Herrera wrote: >Rainer Bauer wrote: >> "Andrej Ricnik-Bay" wrote: >> >> >On Nov 7, 2007 2:40 PM, Rainer Bauer <[EMAIL PROTECTED]> wrote: >> > >> >> That's nice to hear. But I respect licences as they are and the ODBCng &

Re: [GENERAL] list of postgres related unexpected 'features'

Sascha Bohnenkamp wrote: >Is there a list postgres related unexpected 'features', like count(*) is >expensive etc.? >I do not ask to bash postgres, but to use it ... and it would be nice if >I have not to try any pittfall by myself. Something like

Re: [GENERAL] Npsql is much faster than ODBC ?

"Andrej Ricnik-Bay" wrote: >On Nov 7, 2007 2:40 PM, Rainer Bauer <[EMAIL PROTECTED]> wrote: > >> That's nice to hear. But I respect licences as they are and the ODBCng driver >> is licenced under the GPL. >That doesn't mean that you're not allow

Re: [GENERAL] Npsql is much faster than ODBC ?

Greg Smith wrote: >On Wed, 7 Nov 2007, Rainer Bauer wrote: > >> The way I read this section is that linking to a GPL ODBC driver would imply >> that I have to release my program under a GPL (compatible) licence. > >What you actually link against is the ODBC implementa

[GENERAL] Cluster using tablespaces?

Hello, is there a way to instruct cluster to store the temporary created data on a different tablespace (i.e. drive)? If not, wouldn't that have a decent performance impact or is most of the time spend retrieving the data in index order? Rainer ---(end of broadcast)--

Re: [GENERAL] Cluster using tablespaces?

Erik Jones wrote: >> is there a way to instruct cluster to store the temporary created >> data on a >> different tablespace (i.e. drive)? If not, wouldn't that have a decent >> performance impact or is most of the time spend retrieving the data >> in index >> order? > >What temporary created d

Re: [GENERAL] Cluster using tablespaces?

Tom Lane wrote: >Rainer Bauer <[EMAIL PROTECTED]> writes: > >> "During the cluster operation, a temporary copy of the table is created that >> contains the table data in the index order. Temporary copies of each index on >> the table are created as well.&q

Re: [GENERAL] Cluster using tablespaces?

Alvaro Herrera wrote: >Rainer Bauer wrote: >> Ok, I expected that. Does this work: >> ALTER TABLE foo CLUSTER ON index_name SET TABLESPACE new_tablespace >> >> I.e. is the table moved to the other tablespace and clustered at the same >> time >> or are t

Re: [GENERAL] Cluster using tablespaces?

Alvaro Herrera wrote: > Alvaro Herrera wrote: >Probably most of the time is going into creating the new table then. > >If you are looking for a short-term solution to your problem, maybe the >best is to follow the recommendation on CLUSTER ref page: I've read that section before, but I have lots

[GENERAL] Is news.postgresql.org down?

Hello, I cannot retrieve any list messages through the news server anymore (since last Tuesday). Are there any known problems? The reported error is: "503 NNTP server unavailable". Rainer ---(end of broadcast)--- TIP 3: Have you checked our exten

Re: [GENERAL] Is news.postgresql.org down?

Hello Magnus, MH> Yes, it's been down for quite a long time. AFAIK, Marc has a plan for MH> fixing it, but I don't know the timeframe. Thanks Magnus. I was not sure whether it was really the server. Hopefully it won't be down for too long as I use a newsreader to read the lists. Rainer ---

Re: [GENERAL] [pgsql-general] Daily digest v1.8030 (22 messages)

Tom Lane wrote: >"Brett Hoerner" <[EMAIL PROTECTED]> writes: >> On Mon, Mar 31, 2008 at 10:54 AM, Colin Wetherbee <[EMAIL PROTECTED]> wrote: >>> I received eight of these unwanted digests last night and early this >>> morning, after never seeing them before. Is this a new configuration >>> change

Re: [GENERAL] lc_messages 8.3.7

Alvaro Herrera wrote: >Hmm, it works fine for me (not Windows though): The lc_messages setting is broken in 8.3 under Windows (not sure whether this will be fixed in 8.4): Rainer -- Sent via pgsql-general mailing list (pgsql-gene

Re: [GENERAL] c++ program to connect to postgre database

John R Pierce schrieb: >ramon rhey serrano wrote: >> Hi Sir John, >> >> Thanks for the links and reply. >> I downloaded this "libpqxx-3.0" but i really don't know what to do >> with the file and where to put them. I'm still having hard time how to >> start the C++ program using Dev C++ as my IDE

Re: [GENERAL] Postgres memory question

Kobus Wolvaardt schrieb: >We have software deployed on our network that need postgres, we have server >that hosts the server and all worked fine until we crossed about 200 users. >The application is written so that it makes a connection right at the start >and keeps it alive for the duration of th

Re: [GENERAL] No download of Windows binaries without registering?

Thomas Kellerer schrieb: >If one goes directly http://www.enterprisedb.com/products/pgbindownload.do >this is not necessary (which is what I expect), but as far as I can tell, >there is no direct link to that page. You get there from the official PostgreSQL download page:

[GENERAL] How to change log file language?

Hi all, I installed 8.3.3 on an english WinXP. The database cluster was initialized with server encoding UTF8 and the locale was set to 'German, Germany'. Now all messages in the log and everywhere else are showing up in German (as expected). However I want to see those messages in English. I tri

Re: [GENERAL] How to change log file language?

"Leif B. Kristensen" wrote: >I don't know how this is handled in Windows, but on a Linux computer you >can enter the directory /usr/local/share/locale/de/LC_MESSAGES/ and >just rename or delete the file psql.mo. Thanks for the tipp: After renaming folder C:\Program Files\PostgreSQL\8.3\share\lo

Re: [GENERAL] Tips on how to efficiently debugging PL/PGSQL

Glyn Astill wrote: >> From: [EMAIL PROTECTED] <[EMAIL PROTECTED]> >> Just to seek some tips on how to efficiently debug PL/SQL. >> >edb have a debugger that intigrates with pgadmin > >http://pgfoundry.org/projects/edb-debugger/ This debugger is integrated with pgAdminIII that is shipped with Pos

Re: [GENERAL] Cannot remember what to do to get the information_schema, pg_catalog etc showing.

Johan Nel wrote: >Did an installation of PostgreSQL on a new laptop and I just cannot >remember which .sql script to run to have the above schemas showing in >pgAdmin or is it something to do with a checkbox/setting during >installation? File > Options... > Display > [x] Show System Objects in

[GENERAL] Missing usenet messages. Was: A bit confused about Postgres Plus

Hi all, Thomas Kellerer wrote here > [I'm reading this list through the newsserver at news.gmane.org, > and several answers did not seem to make it to news.gmane.org > but only to my private email] I am reading the Postgres list

Re: [GENERAL] Missing usenet messages. Was: A bit confused about Postgres Plus

Alvaro Herrera wrote: >Rainer Bauer wrote: >> >> It seems like Alvaros message was sent only via private mail, because it does >> not show in the mailing list archive. > >It is on the archives, here: >http://archives.postgresql.org/message-id/20081217122802.GA44

[GENERAL] Usenet gateway not working

Hello, seems like the usenet gateway is down again (my last successful contact to news.postgresql.org dates back 10 days). Is this a known problem? Rainer -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mail

Re: [GENERAL] Space for pg_dump

Greg Smith wrote: >On Tue, 31 Mar 2009, Scott Marlowe wrote: > >> Sadly, there is no exact maths for such things. If your database has >> tons of indexes and such, it might be 20 or 100 times bigger on disk >> than it will be during backup. If it's all compressible text with few >> indexes, it m

[GENERAL] Community account

Hello, I signed up a couple of months ago but never received the confirmation email. If I try to create a new account with the same email address, but a different handle it is denied with this error message: "A user with that email already exists". When I click on the 'lost password' link and en

Re: [GENERAL] Community account

Hello Scott, Saturday, April 18, 2009, 4:21:29 PM, you wrote: SM> On Sat, Apr 18, 2009 at 3:49 AM, Rainer Bauer wrote: >> Hello, >> >> I signed up a couple of months ago but never received the confirmation email. >> >> If I try to create a new account w

Re: [GENERAL] Community account

Hello Magnus, Sunday, April 19, 2009, 11:05:49 AM, you wrote: MH> I assume you are trying to register as inqu...@munnin.com? Yep. MH> So we are trying to deliver this to your domain, but appear to be MH> repeatedly graylisted by the different MX machines. And when we try MH> again, we're put ba

Re: [GENERAL] Community account

Hello Magnus, Sunday, April 19, 2009, 11:05:49 AM, you wrote: MH> You need to have the email system give us at least a chance to get off MH> the graylist :-) Or you need to whitelist the wwwmaster.postgresql.org MH> domain. It was whitelisted and works now like a charm. Thanks, Magnus! I suppos