Re: [GENERAL] arrays as parameters to pl/pgsql functions
On Mon, 17 Nov 2003, Julie May wrote:
> Is it possible to use an array as a parameter to a pl/pgsql function. I am
> running version 7.3 and don't have the time right now to upgrade.If it is
> possible, how do you iterate through the array? For example:
CREATE or REPLACE FUNCTION foo(integer[]) RETURNS int AS
'DECLARE
a alias for $1;
index integer := 1;
total integer := 0;
BEGIN
WHILE a[index] > 0
LOOP
total := total + a[index];
index := index + 1;
END LOOP;
RETURN total;
END;
' LANGUAGE 'plpgsql';
test=> select foo('{1,2}');
foo
-
3
(1 row)
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
[GENERAL] SuSE RPMs available for PostgreSQL 7.4
SuSE RPMs for PostgreSQL 7.4 are available at ftp://ftp.postgresql.org/pub/binary/v7.4/suse or a mirror http://www.postgresql.org/mirrors-www.html or at ftp://ftp.suse.com/pub/people/max/postgresql-7.4 or a mirror http://www.suse.com/us/private/download/ftp/int_mirrors.html http://www.suse.com/us/private/download/ftp/germ_mirrors.html -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [GENERAL] PostgreSQL v7.4 Released
On Mon, 17 Nov 2003, Peter Eisentraut wrote: > Marc G. Fournier writes: > > > After almost 12 months of intense development, and testing, we are proud > > to announce the availability of PostgreSQL v7.4. > > And when will the coordinator learn that it is called "PostgreSQL 7.4" and > not "PostgreSQL v7.4"? Habit :) ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Re: [GENERAL] arrays as parameters to pl/pgsql functions
Thank you Ben, that worked.
- Original Message -
From: "Ben" <[EMAIL PROTECTED]>
To: "Julie May" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, November 17, 2003 3:17 PM
Subject: Re: [GENERAL] arrays as parameters to pl/pgsql functions
> On Mon, 17 Nov 2003, Julie May wrote:
>
> > Is it possible to use an array as a parameter to a pl/pgsql function. I
am
> > running version 7.3 and don't have the time right now to upgrade.If it
is
> > possible, how do you iterate through the array? For example:
>
>
> CREATE or REPLACE FUNCTION foo(integer[]) RETURNS int AS
> 'DECLARE
> a alias for $1;
> index integer := 1;
> total integer := 0;
> BEGIN
> WHILE a[index] > 0
> LOOP
> total := total + a[index];
> index := index + 1;
> END LOOP;
>
> RETURN total;
> END;
> ' LANGUAGE 'plpgsql';
>
>
>
> test=> select foo('{1,2}');
> foo
> -
>3
> (1 row)
>
>
>
> ---(end of broadcast)---
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to [EMAIL PROTECTED] so that your
> message can get through to the mailing list cleanly
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[GENERAL] tracking down temp files
is there some way to determine the query that creates the file
pgsql_tmp15041.0? i thought maybe 15041 was the procpid but apparently
not... anyone know?
Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
[GENERAL] offset for query result ??
Hi all, I know we have LIMIT to limit the number of rows returned, I wonder if there is a way to indicate an offset. e.g. Select * from Test offset 10, limit 4; retrieve all Test, return 4 rows from the 10th row thanks, kathy ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [GENERAL] PostgreSQL v7.4 Released
Marc G. Fournier writes: > > And when will the coordinator learn that it is called "PostgreSQL 7.4" and > > not "PostgreSQL v7.4"? > > Habit :) I would appreciate it if you could abandon that habit and stop making us look like losers. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[GENERAL] Stuck processes, viewing the queries inside
We have a running server (v7.3) which, over time, seems to accumulate a bunch of "stuck" PostgreSQL instances which appear to be dead inside of a transaction. For example, "ps" reveals many of these: postgres 17683 0.0 0.4 7376 1032 ?SNov13 0:21 postgres: bryan sourceid 127.0.0.1 idle in transaction As admin, I'd like to run "psql" and peer inside the system (using the Statistics Collector) to see which queries have been run inside some of these stuck transactions. It will help me debug what's going wrong. This page: http://www.postgresql.org/docs/7.3/static/monitoring-stats.html gives lots of intereseting methods for pulling information on the running state, but I can't see a query for "given a process ID currently in a transaction, show me all the queries which have been run in it so far". Any pointers would be appreciated, Bryan ---(end of broadcast)--- TIP 8: explain analyze is your friend
Re: [GENERAL] embedded postgresql + C++ IDE
Java has long way to catch up with C++ in my opinion. --- "scott.marlowe" <[EMAIL PROTECTED]> wrote: > Yep, it's far more common to find free software for > linux/unix than for > windows, where commercial software tends to rule the > roost. > > If you don't mind developing in Java, look at > javabeans by Sun. quite a > nice little IDE for java. > > On Sat, 15 Nov 2003, jini us wrote: > > > Thank you for your response. > > I was looking for a FREE C++ Integrated > development > > The IDE suggested caters for linux/unix rather > than > > windows. > > > > --- Dann Corbit <[EMAIL PROTECTED]> wrote: > > > > -Original Message- > > > > From: jini us [mailto:[EMAIL PROTECTED] > > > > Sent: Friday, November 14, 2003 2:07 PM > > > > To: Joshua D. Drake > > > > Cc: [EMAIL PROTECTED]; > > > [EMAIL PROTECTED] > > > > Subject: Re: [GENERAL] embedded postgresql + > C++ > > > IDE > > > > > > > > > > > > I am using MS windows so ideally I would like > > > > to get hold of a binary for MS windows > > > > > > Look here: > > > http://techdocs.postgresql.org/guides/Windows > > > > > > > Want to chat instantly with your online friends? > Get the FREE Yahoo! > > Messenger http://mail.messenger.yahoo.co.uk > > > > ---(end of > broadcast)--- > > TIP 9: the planner will ignore your desire to > choose an index scan if your > > joining column's datatypes do not match > > > > > > > ---(end of > broadcast)--- > TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] Want to chat instantly with your online friends? Get the FREE Yahoo! Messenger http://mail.messenger.yahoo.co.uk ---(end of broadcast)--- TIP 8: explain analyze is your friend
Re: [GENERAL] PostgreSQL v7.4 Released
Interesting, I see the difference between "PostgreSQL v7.4 Released" and "PostgreSQL 7.4 Released". But I didn't perceive a "loser" until the Postgres team started squabbling amongst themselves on a public forum about it. Terry Fielder Manager Software Development and Deployment Great Gulf Homes / Ashton Woods Homes [EMAIL PROTECTED] Fax: (416) 441-9085 > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Peter > Eisentraut > Sent: Monday, November 17, 2003 6:35 PM > To: Marc G. Fournier > Cc: [EMAIL PROTECTED] > Subject: Re: [GENERAL] PostgreSQL v7.4 Released > > > Marc G. Fournier writes: > > > > And when will the coordinator learn that it is called > "PostgreSQL 7.4" and > > > not "PostgreSQL v7.4"? > > > > Habit :) > > I would appreciate it if you could abandon that habit and > stop making us > look like losers. > > -- > Peter Eisentraut [EMAIL PROTECTED] > > > ---(end of > broadcast)--- > TIP 1: subscribe and unsubscribe commands go to > [EMAIL PROTECTED] > ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
Re: [GENERAL] offset for query result ??
Kathy Zhu wrote:
I know we have LIMIT to limit the number of rows returned, I wonder if there is
a way to indicate an offset.
Select * from Test offset 10, limit 4;
As per the PostgreSQL documentation, specifically the page on the
"SELECT" SQL command:
LIMIT Clause
LIMIT { count | ALL }
OFFSET start
where count specifies the maximum number of rows to return, and start
specifies the number of rows to skip before starting to return rows.
so the query you want is:
SELECT * FROM Test LIMIT 4 OFFSET 10;
Alex
---(end of broadcast)---
TIP 8: explain analyze is your friend
Re: [GENERAL] embedded postgresql + C++ IDE
Although java is quite strong when building distributed applications,web application, small devices. Anyway Java is owned by sun microsystems and it is their attempt to catch up with microsoft. That doesn't benefit me any way... waiting for sun microsystems and their partners (majority based in india) to re-invent the wheel. Java has also been taken up by many other tool vendors so that they can make some money. Tool vendors who are also re-inventing the wheel. C++ on the hand is owned by nobody but an invention by stroustrap aimed at application developers. --- jini us <[EMAIL PROTECTED]> wrote: > > Java has long way to catch up with C++ > in my opinion. > > --- "scott.marlowe" <[EMAIL PROTECTED]> wrote: > > > Yep, it's far more common to find free software for > > linux/unix than for > > windows, where commercial software tends to rule > the > > roost. > > > > If you don't mind developing in Java, look at > > javabeans by Sun. quite a > > nice little IDE for java. > > > > On Sat, 15 Nov 2003, jini us wrote: > > > > > Thank you for your response. > > > I was looking for a FREE C++ Integrated > > development > > > The IDE suggested caters for linux/unix rather > > than > > > windows. > > > > > > --- Dann Corbit <[EMAIL PROTECTED]> wrote: > > > > > -Original Message- > > > > > From: jini us [mailto:[EMAIL PROTECTED] > > > > > Sent: Friday, November 14, 2003 2:07 PM > > > > > To: Joshua D. Drake > > > > > Cc: [EMAIL PROTECTED]; > > > > [EMAIL PROTECTED] > > > > > Subject: Re: [GENERAL] embedded postgresql + > > C++ > > > > IDE > > > > > > > > > > > > > > > I am using MS windows so ideally I would > like > > > > > to get hold of a binary for MS windows > > > > > > > > Look here: > > > > http://techdocs.postgresql.org/guides/Windows > > > > > > > > > > > > Want to chat instantly with your online friends? > > > Get the FREE Yahoo! > > > Messenger http://mail.messenger.yahoo.co.uk > > > > > > ---(end of > > broadcast)--- > > > TIP 9: the planner will ignore your desire to > > choose an index scan if your > > > joining column's datatypes do not match > > > > > > > > > > > > ---(end of > > broadcast)--- > > TIP 1: subscribe and unsubscribe commands go to > [EMAIL PROTECTED] > > > Want to chat instantly with your online friends? > Get the FREE Yahoo! > Messenger http://mail.messenger.yahoo.co.uk > > ---(end of > broadcast)--- > TIP 8: explain analyze is your friend Want to chat instantly with your online friends? Get the FREE Yahoo! Messenger http://mail.messenger.yahoo.co.uk ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
Re: [GENERAL] PostgreSQL v7.4 Released
On Mon, 2003-11-17 at 15:35, Peter Eisentraut wrote: I would appreciate it if you could abandon that habit and stop making us look like losers. Losers? PostgreSQL is way too good for it to be the product of losers. My Oracle-bound comrades have drooled over things like table inheritance and server-side functions in perl and python. I can tell you that they're the ones who've felt like they're losing something. Hackers, thanks again for 7.4 (and Marc, thanks for v7.4). -Reece -- Reece Hart, http://www.in-machina.com/~reece/, GPG:0x25EC91A0
Re: [GENERAL] embedded postgresql + C++ IDE
On Mon, 17 Nov 2003 23:48:46 + (GMT) jini us <[EMAIL PROTECTED]> wrote: > Java has long way to catch up with C++ > in my opinion. perhaps. this is neither the time nor the place for that discussion. however, in answer to the actual discussion in this thread, netbeans (not javabeans) is a nice pseudo open-source IDE (no charge, and it's open source to the extent that the Sun Public Licence is open source, which is to say sort of but not really). see http://www.netbeans.org/ for a copy, but be sure that your development system has enough RAM -- and you'll want to watch the netbeans users list for performance tips, as there are a lot of tweaks to the default memory management parameters that are worth making. it happens to have a C++ module which can be downloaded and added; i've played with it a bit. only downside is that the runtime and debugger aren't really integrated; i find myself editing C++, saving it, and going to a shell window to run the makefile, which isn't nearly as slick as when i do java development in the IDE. richard -- Richard Welty [EMAIL PROTECTED] Averill Park Networking 518-573-7592 Java, PHP, PostgreSQL, Unix, Linux, IP Network Engineering, Security ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [GENERAL] embedded postgresql + C++ IDE
Eclipse also has a nice c++ plugin. Richard Welty wrote: On Mon, 17 Nov 2003 23:48:46 + (GMT) jini us <[EMAIL PROTECTED]> wrote: Java has long way to catch up with C++ in my opinion. perhaps. this is neither the time nor the place for that discussion. however, in answer to the actual discussion in this thread, netbeans (not javabeans) is a nice pseudo open-source IDE (no charge, and it's open source to the extent that the Sun Public Licence is open source, which is to say sort of but not really). see http://www.netbeans.org/ for a copy, but be sure that your development system has enough RAM -- and you'll want to watch the netbeans users list for performance tips, as there are a lot of tweaks to the default memory management parameters that are worth making. it happens to have a C++ module which can be downloaded and added; i've played with it a bit. only downside is that the runtime and debugger aren't really integrated; i find myself editing C++, saving it, and going to a shell window to run the makefile, which isn't nearly as slick as when i do java development in the IDE. richard -- Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC Postgresql support, programming shared hosting and dedicated hosting. +1-503-222-2783 - [EMAIL PROTECTED] - http://www.commandprompt.com Editor-N-Chief - PostgreSQl.Org - http://www.postgresql.org ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
[GENERAL] Take a minute to make yourself heard ... (PostgreSQL vs ...)
G'day all ... There is polling going on over at LinuxQuestions.Org for "Members Choice Awards", with, of course, there being a category for Database of the Year ... Right now, as of this writing, we are in second place, with 36 votes vs 110 votes for MySQL ... It is a registered thing, but the registration form is quite short ... --- Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: [EMAIL PROTECTED] Yahoo!: yscrappy ICQ: 7615664 ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
[GENERAL] PostgreSQL v7.4 Released
After almost 12 months of intense development, and testing, we are proud to announce the availability of PostgreSQL v7.4. An overview of the major changes in v7.4 include: IN/NOT IN subqueries are now much more efficient Improved GROUP BY processing by using hash buckets New multikey hash join capability Queries using the explicit JOIN syntax are now better optimized Faster and more powerful regular expression code Function-inlining for simple SQL functions Full support for IPv6 connections and IPv6 address data types Major improvements in SSL performance and reliability Make free space map efficiently reuse empty index pages, and other SQL-standard information schema Cursors conform more closely to the SQL standard Cursors can exist outside transactions New client-to-server protocol libpq and ECPG applications are now fully thread-safe New version of full-text indexing New autovacuum tool Array handling has been improved and moved into the server core For a full listing of what has changed between v7.3 and v7.4, please see the HISTORY file available at: http://developer.postgresql.org/~momjian/HISTORY.html For a look at the Official Press Release that our Advocacy team *slaved* over for the many weeks preceeding the release, it is available at: http://www.postgresql.org/presskit/en/presskit74.html For this release, we have two primary methods of downloading, in two different formats ... For those using BitTorrent (http://bitconjurer.org/BitTorrent/), we have setup a BitTorrent server at: http://bt.postgresql.org For those using FTP, please see our listing of mirror sites for a location near you: http://www.postgresql.org/mirrors-www.html And, due to popular demand over the years, we've finally given in and are offering both .gz and .bz versions, both through FTP and BitTorrent. Any questions/problems with release, please report them, as always, to [EMAIL PROTECTED] Marc G. Fournier Coordinator PostgreSQL Global Development Group ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
Re: [GENERAL] PostgreSQL v7.4 Released
On Mon, 17 Nov 2003 [EMAIL PROTECTED] wrote: > Interesting, I see the difference between "PostgreSQL v7.4 Released" and > "PostgreSQL 7.4 Released". And, until Peter pointed it out to you, did you notice the difference? ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
Re: [GENERAL] PostgreSQL v7.4 Released
On Tue, 18 Nov 2003, Peter Eisentraut wrote: > Marc G. Fournier writes: > > > > And when will the coordinator learn that it is called "PostgreSQL 7.4" and > > > not "PostgreSQL v7.4"? > > > > Habit :) > > I would appreciate it if you could abandon that habit and stop making us > look like losers. Odd that you are the only one that *ever* seems to take offence at it ... *shrug* ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [GENERAL] PostgreSQL v7.4 Released
[EMAIL PROTECTED] wrote: Interesting, I see the difference between "PostgreSQL v7.4 Released" and "PostgreSQL 7.4 Released". But I didn't perceive a "loser" until the Postgres team started squabbling amongst themselves on a public forum about it. No losers here :-) Great job guys ! .Sig - Speeling impaired welcome here. ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [GENERAL] PostgreSQL v7.4 Released
Not really, and still don't care either way. Postgres *is* a superior product, I have used many different DB's, and will continue to stick by Postgres. And THAT is what makes Postgres stand out from the rest: let's get over it. Terry Fielder Manager Software Development and Deployment Great Gulf Homes / Ashton Woods Homes [EMAIL PROTECTED] Fax: (416) 441-9085 > -Original Message- > From: Marc G. Fournier [mailto:[EMAIL PROTECTED] > Sent: Monday, November 17, 2003 7:49 PM > To: [EMAIL PROTECTED] > Cc: 'Peter Eisentraut'; 'Marc G. Fournier'; > [EMAIL PROTECTED] > Subject: RE: [GENERAL] PostgreSQL v7.4 Released > > > On Mon, 17 Nov 2003 [EMAIL PROTECTED] wrote: > > > Interesting, I see the difference between "PostgreSQL v7.4 > Released" and > > "PostgreSQL 7.4 Released". > > And, until Peter pointed it out to you, did you notice the difference? > ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [GENERAL] PostgreSQL v7.4 Released
Marc G. Fournier writes: > Odd that you are the only one that *ever* seems to take offence at it ... > *shrug* Here it's just the release announcements that make us look like some kind of weirdos. But when you're making tarballs like erserver_v1.2.tar.gz then you're not only making a fool of yourself, you're creating actual technical problems. I take offense at it because for years you've simply ignored all requests to do something about it. But I'm certainly not the only one who considers it odd. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [GENERAL] PostgreSQL v7.4 Released
I would appreciate it if you could abandon that habit and stop making us look like losers. Odd that you are the only one that *ever* seems to take offence at it ... *shrug* I don't even understand why we are declaring a difference. Is it not v7.4? ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster -- Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC Postgresql support, programming shared hosting and dedicated hosting. +1-503-222-2783 - [EMAIL PROTECTED] - http://www.commandprompt.com Editor-N-Chief - PostgreSQl.Org - http://www.postgresql.org ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
Re: [GENERAL] PostgreSQL v7.4 Released
Here it's just the release announcements that make us look like some kind of weirdos. But when you're making tarballs like erserver_v1.2.tar.gz then you're not only making a fool of yourself, you're creating actual technical problems. I take offense at it because for years you've simply ignored all requests to do something about it. But I'm certainly not the only one who considers it odd. Somebody please explain to me what the hell a difference it makes if we have a v in front of the version number? Sincerely, Joshua Drake -- Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC Postgresql support, programming shared hosting and dedicated hosting. +1-503-222-2783 - [EMAIL PROTECTED] - http://www.commandprompt.com Editor-N-Chief - PostgreSQl.Org - http://www.postgresql.org ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Re: [GENERAL] PostgreSQL v7.4 Released
Joshua D. Drake writes: > Somebody please explain to me what the hell a difference it makes if > we have a v in front of the version number? Packaging tools, packaging standards, convention, consistency of public presentation. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [GENERAL] PostgreSQL v7.4 Released
Joshua D. Drake wrote: > Here it's just the release announcements that make us look like some kind > > >of weirdos. But when you're making tarballs like erserver_v1.2.tar.gz > >then you're not only making a fool of yourself, you're creating actual > >technical problems. I take offense at it because for years you've simply > >ignored all requests to do something about it. But I'm certainly not the > >only one who considers it odd. > > > > > > > Somebody please explain to me what the hell a difference it makes if > we have a v in front of the version number? I certainly don't mind the v, or I vertainly don't vind the v. :-) -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [GENERAL] PostgreSQL v7.4 Released
On Mon, 17 Nov 2003, Joshua D. Drake wrote: > Here it's just the release announcements that make us look like some kind > > >of weirdos. But when you're making tarballs like erserver_v1.2.tar.gz > >then you're not only making a fool of yourself, you're creating actual > >technical problems. I take offense at it because for years you've simply > >ignored all requests to do something about it. But I'm certainly not the > >only one who considers it odd. > > > > > > > Somebody please explain to me what the hell a difference it makes if > we have a v in front of the version number? *shrug* v == version ... maybe its offending Peter that I'm being redundant or something? Stating the obvious by putting the v in front of the version #? ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Re: [GENERAL] PostgreSQL v7.4 Released
On Tue, 2003-11-18 at 01:55, Joshua D. Drake wrote: > Somebody please explain to me what the hell a difference it makes if > we have a v in front of the version number? It isn't standard practice. I agree with Peter on this. Also, as I have asked before, please make sure that future releases sort in the correct order. It makes life much easier for those of us who make packages and the many users who install packages. The cycle of releases we have had were: 7.4beta[1-5] 7.4RC[12] 7.4 These sort in reverse (ASCII) order to their real priority. So the series of Debian packages were numbered: 7.3.99.7.4beta[1-5] 7.3.99.7.4rc[12] 7.4 I hope users who were tracking these understood the relationship between Marc's numbers and mine. -- Oliver Elphick[EMAIL PROTECTED] Isle of Wight, UK http://www.lfix.co.uk/oliver GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C "A Song for the sabbath day. It is a good thing to give thanks unto the LORD, and to sing praises unto thy name, O most High." Psalms 92:1 ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Re: [GENERAL] PostgreSQL v7.4 Released
On Tue, 18 Nov 2003, Peter Eisentraut wrote: > Joshua D. Drake writes: > > > Somebody please explain to me what the hell a difference it makes if > > we have a v in front of the version number? > > Packaging tools, packaging standards, convention, consistency of public > presentation. Packaging has always been straight: svr1# ls -l */postgresql-7.?.tar.gz -rw-rw-r-- 1 pgsql pgsql 9173732 May 9 2000 v7.0/postgresql-7.0.tar.gz -rw-r--r-- 1 pgsql pgsql 8088678 Apr 13 2001 v7.1/postgresql-7.1.tar.gz -rw-r--r-- 1 pgsql pgsql 9180168 Feb 4 2002 v7.2/postgresql-7.2.tar.gz -rw-r--r-- 1 pgsql pgsql 11059455 Nov 27 2002 v7.3/postgresql-7.3.tar.gz -rw-r--r-- 1 pgsql pgsql 12311256 Nov 16 17:57 v7.4/postgresql-7.4.tar.gz Its just in the text/subjects that I put the v ... *shrug* ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [GENERAL] PostgreSQL v7.4 Released
And all along I thought "v" stood for "victory" we launched 7.4! Seriously huge effort, great product, cheers! Another great milestone. Cheers to the veam, I mean team. -Original Message- From: Peter Eisentraut [mailto:[EMAIL PROTECTED] Sent: Mon 11/17/2003 9:10 PM To: Joshua D. Drake Cc: Marc G. Fournier; [EMAIL PROTECTED] Subject: Re: [GENERAL] PostgreSQL v7.4 Released Joshua D. Drake writes: > Somebody please explain to me what the hell a difference it makes if > we have a v in front of the version number? Packaging tools, packaging standards, convention, consistency of public presentation. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match ---(end of broadcast)--- TIP 8: explain analyze is your friend
Re: [GENERAL] tracking down temp files
Robert Treat wrote: > is there some way to determine the query that creates the file > pgsql_tmp15041.0? i thought maybe 15041 was the procpid but apparently > not... anyone know? It is the proc id. Perhaps the backend crashed. If so, a postmaster restart clears those sort directories. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 8: explain analyze is your friend
Re: [GENERAL] snort, acid and postgres
Well, it usually takes atleast 15-20 minutes to get results back on a database that has many alerts in it. The system itself is dual pentium 4 1 GHZ with 1 GByte of RAM. I have been talking to a few people and they mentioned trying to update the memory space for which postgres uses by tweaking freebsd and also postrgesql.conf itself? I have done some vacuuming on the database itself. I guess I just need to optimize the speed of the system as much as possible. Jeremy Dann Corbit wrote: > > > -Original Message- > > From: Jeremy Hefner [mailto:[EMAIL PROTECTED] > > Sent: Monday, November 17, 2003 12:15 PM > > To: [EMAIL PROTECTED] > > Subject: [GENERAL] snort, acid and postgres > > > > > > Ok, so here is my problem. I am running snort with ACID as > > the query interface and FreeBSD with Postgresql 7.2 as the > > back end database system. > > What kind of hardware is the FreeBSD OS running on? How much memory? > What sort of disk subsystem? > > > The problem I am encountering is > > that it takes forever for acid to query the database and > > delete alerts. > > How long is "forever"? That seems a bit vague. > > > Also, there is no way to have more than one > > person query the database without having it crawl. > > There are PostgreSQL database systems with thousands of simultaneous > users. Perhaps you can clarify your question a bit. > > > Is there > > anyone out there that has experience tweaking postgres so > > that it performs faster in this setup? The database is out of > > the box with no tweaks to it. > > Probably, some additional information would be helpful. > > If you know the queries that you are sending, try an analyze to see what > sort of plan is used. > > Have you done any vacuum operations on your database? ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
