Re: [HACKERS] 8.3.0 Core with concurrent vacuum fulls

2008-03-05 Thread Gavin M. Roy
]: [19-1] LOG: terminating any other active server processes 2008-03-04 05:47:55 EST [6741]: [12-1] WARNING: terminating connection because of crash of another server process On Tue, Mar 4, 2008 at 9:56 PM, Tom Lane [EMAIL PROTECTED] wrote: Gavin M. Roy [EMAIL PROTECTED] writes: (gdb) where

Re: [HACKERS] 8.3.0 Core with concurrent vacuum fulls

2008-03-05 Thread Gavin M. Roy
On Wed, Mar 5, 2008 at 10:13 AM, Tom Lane [EMAIL PROTECTED] wrote: I wrote: In particular, if that's the problem, why has this not been seen before? The fact that it's going through heap_page_prune doesn't seem very relevant --- VACUUM FULL has certainly always had to invoke

Re: [HACKERS] 8.3.0 Core with concurrent vacuum fulls

2008-03-05 Thread Gavin M. Roy
On Wed, Mar 5, 2008 at 10:31 AM, Tom Lane [EMAIL PROTECTED] wrote: Gavin M. Roy [EMAIL PROTECTED] writes: 2008-03-04 05:45:47 EST [6698]: [1-1] LOG: process 6698 still waiting for AccessShareLock on relation 1247 of database 16385 after 1001.519 ms 2008-03-04 05:45:47 EST [6698]: [2-1

Re: [HACKERS] 8.3.0 Core with concurrent vacuum fulls

2008-03-05 Thread Gavin M. Roy
On Wed, Mar 5, 2008 at 10:31 AM, Tom Lane [EMAIL PROTECTED] wrote: Gavin M. Roy [EMAIL PROTECTED] writes: 2008-03-04 05:45:47 EST [6698]: [1-1] LOG: process 6698 still waiting for AccessShareLock on relation 1247 of database 16385 after 1001.519 ms 2008-03-04 05:45:47 EST [6698]: [2-1

Re: [HACKERS] 8.3.0 Core with concurrent vacuum fulls

2008-03-05 Thread Gavin M. Roy
by process 6742. 2008-03-04 05:45:20 EST [6742]: [9-1] STATEMENT: VACUUM FULL pg_catalog.pg_type Sorry, been juggling too many things this morning! On Wed, Mar 5, 2008 at 10:45 AM, Tom Lane [EMAIL PROTECTED] wrote: Gavin M. Roy [EMAIL PROTECTED] writes: The panic may have made it if this is what

[HACKERS] 8.3.0 Core with concurrent vacuum fulls

2008-03-04 Thread Gavin M. Roy
This morning I had a postgres 8.3 install core this morning while multiple vacuum fulls were taking place. I saved the core file, would anyone be interested in dissecting it? I've otherwise had no issues with this machine or pgsql install. Gavin

Re: [HACKERS] 8.3.0 Core with concurrent vacuum fulls

2008-03-04 Thread Gavin M. Roy
0x0050 in PostmasterMain () #20 0x0052fd3e in main () On Tue, Mar 4, 2008 at 11:35 AM, Alvaro Herrera [EMAIL PROTECTED] wrote: Gavin M. Roy wrote: This morning I had a postgres 8.3 install core this morning while multiple vacuum fulls were taking place. I saved the core file, would

Re: [HACKERS] 8.3devel slower than 8.2 under read-only load

2007-11-24 Thread Gavin M. Roy
On 11/24/07, Gregory Stark [EMAIL PROTECTED] wrote: This is a conflict which will affect Postgres in the future as well. Generally I/O costs win over cpu costs in databases since only relatively small systems are cpu-bound. Large systems are typically I/O-bound. That really depends on

Re: [HACKERS] Machine available for community use

2007-11-02 Thread Gavin M. Roy
after themselves data usage wise after their scheduled time? Should people only be able to run PostgreSQL in the context of their own user? Do we have experience with such setups in the past? What has worked well and what hasn't? Gavin On 7/25/07, Gavin M. Roy [EMAIL PROTECTED] wrote: Recently

Re: [HACKERS] Machine available for community use

2007-08-01 Thread Gavin M. Roy
Let us know when/if and we'll pay command prompt to install the base OS on the system. All that we're waiting on at this point is the final on the OS. Gavin On 7/31/07, Tom Lane [EMAIL PROTECTED] wrote: Josh Berkus [EMAIL PROTECTED] writes: Hey, this is looking like a serious case of Bike

Re: [HACKERS] Machine available for community use

2007-07-31 Thread Gavin M. Roy
It's actually in Texas, and we have no intention to put a time limit on its availability. I think the availability will be there as long as there is use and we're in the Texas data center, which I don't see ending any time soon. On 7/31/07, Josh Berkus [EMAIL PROTECTED] wrote: Gavin, I'm

Re: [HACKERS] Machine available for community use

2007-07-26 Thread Gavin M. Roy
Let me look at what makes sense there, I am open to it. On 7/26/07, Tom Lane [EMAIL PROTECTED] wrote: Greg Smith [EMAIL PROTECTED] writes: But this is pushing forward PostgreSQL development you're doing here. If you've got a problem such that something works differently based on the order

[HACKERS] Machine available for community use

2007-07-25 Thread Gavin M. Roy
from it as opposed to it being a play sandbox for people who want to tinker. Please let me know thoughts, concerns or suggestions. Gavin M. Roy CTO myYearbook.com [EMAIL PROTECTED] /proc/cpuinfo: processor : 0 vendor_id : AuthenticAMD cpu family : 15 model : 33 model name

Re: [HACKERS] Machine available for community use

2007-07-25 Thread Gavin M. Roy
If you're interested in using the box, name what you want installed. On 7/25/07, Tom Lane [EMAIL PROTECTED] wrote: Gavin M. Roy [EMAIL PROTECTED] writes: I'm currently in the process of having Gentoo linux reinstalled on the box since that is what I am most comfortable administering from

Re: [HACKERS] Machine available for community use

2007-07-25 Thread Gavin M. Roy
Note it's a 28 disk system, and I can allocate more if needed, but I was going to use one MSA for internal use. On 7/25/07, Mark Wong [EMAIL PROTECTED] wrote: On 7/25/07, Tom Lane [EMAIL PROTECTED] wrote: Gavin M. Roy [EMAIL PROTECTED] writes: I'm currently in the process of having Gentoo

Re: [HACKERS] Machine available for community use

2007-07-25 Thread Gavin M. Roy
Ubuntu server? Slackware? Not a fan of Centos, RHEL or Fedora... What about on the BSD side of things? On 7/25/07, Tom Lane [EMAIL PROTECTED] wrote: Gavin M. Roy [EMAIL PROTECTED] writes: If you're interested in using the box, name what you want installed. Personally I use Fedora

Re: [HACKERS] Machine available for community use

2007-07-25 Thread Gavin M. Roy
If RH can sponsor a license of RHEL I'm inclined to go there. Not that it was offered, but I think Dave's suggestion was Tom could field that for the box if inclined. If I'm wrong, let me know. If that can't happen, would people prefer CentOS or Ubuntu Server? The people I'm most concerned

Re: [HACKERS] Machine available for community use

2007-07-25 Thread Gavin M. Roy
One thing to take into account is I dont have physical access to the box (It is in TX, I am in PA). All installs but Gentoo will be performed by a well trained NOC monkey. *cough* On 7/25/07, Dave Page [EMAIL PROTECTED] wrote: --- Original Message --- From: Tom Lane [EMAIL

[HACKERS] pg_dump ignore tablespaces

2007-07-14 Thread Gavin M. Roy
Recently I ran into an issue where restoring from pg_dump from one machine to another with non-matching tablespaces. The primary issue is that index creation will fail if the tablespace does not exist from the dump. I was thinking to best solution for this would be a pg_dump option such as

Re: [HACKERS] [ANNOUNCE] Welcome Core Team member Dave Page

2005-08-25 Thread Gavin M. Roy
the project for a few years will agree. So, welcome Dave Page as the newest member of Core! -- --Josh Berkus Josh Berkus PostgreSQL Project Core Team www.postgresql.org ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster Gavin M. Roy 800

Re: [HACKERS] US Census database (Tiger 2004FE) - 4.4G

2005-08-04 Thread Gavin M. Roy
of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org Gavin M. Roy 800 Pound Gorilla [EMAIL PROTECTED] ---(end of broadcast)--- TIP 4: Have you searched our list archives

Re: [HACKERS] inclusions WAS: Increased company involvement

2005-05-04 Thread Gavin M. Roy
Joshua D. Drake wrote: PgFoundry is coming along in its own right. I see three main problems with it at current: 1. It looks like a separate project from PostgreSQL (website, name, etc...) I've been working on porting the site to use a derived theme from the main PostgreSQL site. My main

Re: [HACKERS] [GENERAL] PHP/PDO Database Abstraction Layer

2005-02-09 Thread Gavin M. Roy
PDO just went into beta, and can be downloaded from http://pecl.php.net/package/pdo to be compiled into previous versions of PHP. We really should get some PHP and PgSQL people onto making sure the PgSQL driver is top notch (if it isn't already). Gavin On Mon, 2005-02-07 at 20:21 -0800,

Re: [HACKERS] Beta5 now Available

2004-11-24 Thread Gavin M. Roy
No you can not, but the tracker isn't very resource intesive from my past experience. I can host it if needed. Gavin Marc G. Fournier wrote: On Wed, 24 Nov 2004, Thomas Hallgren wrote: Gaetano Mendola wrote: ...so the very first client is the real server that must be run 24/24. I don't think

Re: [HACKERS] Beta5 now Available

2004-11-24 Thread Gavin M. Roy
, but if we're really interested, maybe we could hack up the code to talk to a central pgsql database allowing multiple trackers on a dns rr. Gavin Marc G. Fournier wrote: On Wed, 24 Nov 2004, Joshua D. Drake wrote: Marc G. Fournier wrote: On Wed, 24 Nov 2004, Gavin M. Roy wrote: No you can

Re: [HACKERS] Beta5 now Available

2004-11-22 Thread Gavin M. Roy
The problem is it requires a box with X on it. (ie it's not console Java, it's gui java) I don't have a server to run it on right now, but will be readdressing server allocations shortly and may be able to set something up with x/vnc and would be happy to use that as a primary bt seeding

Re: [HACKERS] Beta5 now Available

2004-11-22 Thread Gavin M. Roy
It's all peer to peer client type stuff with the exception of the tracker server. Gavin Marc G. Fournier wrote: On Mon, 22 Nov 2004, Thomas Hallgren wrote: Marc G. Fournier wrote: What about the Java version that Gavin had mentioned? Aegus or something like that?

[HACKERS] 8.0 Beta Thank You

2004-08-09 Thread Gavin M. Roy
Let me be one of the first to say thank you to all of you guys for yet another awesome version of PgSQL, beta or not. My company and I appreciate all the hard work and such that has gone into making this version happen. Keep up the good work and let me know where I can help. Sincerely, Gavin

Re: [HACKERS] localhost redux

2004-07-20 Thread Gavin M. Roy
Yeah, I was talking about it on freenode yesterday. If the stats collector doesn't start, the internal variable is set to off. Gavin Gaetano Mendola wrote: Gavin M. Roy wrote: I have no problem resolving localhost anywhere else on the box, do you have any suggestions on finding out if it's

[HACKERS] localhost redux

2004-07-19 Thread Gavin M. Roy
I've been having a problem with the pgstat.c localhost change since 7.4, in that statistics gathering stopped working on my gentoo boxes. I've not traced it back beyond getaddrinfo called in getaddrinfo_all, and decided the quick fix was to go back and change pgstat to use 127.0.0.1 instead

Re: [HACKERS] localhost redux

2004-07-19 Thread Gavin M. Roy
I have no problem resolving localhost anywhere else on the box, do you have any suggestions on finding out if it's a misconfiguration? Gavin Tom Lane wrote: Gavin M. Roy [EMAIL PROTECTED] writes: I've been having a problem with the pgstat.c localhost change since 7.4, in that statistics

Re: [HACKERS] [ADMIN] Any Gentoo users interested in a slotted PostgreSQL

2004-02-28 Thread Gavin M. Roy
I dont see a real need for slots, but I do question why the 7.4 branch isnt marked as stable yet. :) Gavin Jyry Kuukkanen wrote: Hello Are there any Gentoo users here? Yes, there are some :) Do you wish the PostgreSQL ebuild made use of SLOTS? - to allow installing of major