On Wed, May 02, 2007 at 05:59:49PM -0400, Tom Lane wrote:
> Stephen Harris <[EMAIL PROTECTED]> writes:
> > "select stuff from table where index_key in (" .
> > join(",",keys %hash) . ") AND non_index_row in ('xyz','abc',
On Wed, May 02, 2007 at 12:45:08PM -0700, Dann Corbit wrote:
> Have you done a vacuum on the table recently?
We vacuum daily and cluster weekly after the nightly activities have been
performed.
> IN list, then the IN list might benefit from a bit of analysis for
The IN list is just a set of inte
Postgres version 8.0.9 on Solaris 2.8. I know it's old but...
I have a table with a million rows.
I need to select data from this table based on an indexed column; I need
to select 600 possible values from the column, returning around 24,000
rows of data.
In perl I have a hash which has 600 key
On Wed, Mar 28, 2007 at 11:36:27AM -0400, Tom Lane wrote:
> Stephen Harris <[EMAIL PROTECTED]> writes:
> > INFO: "sweep_users": found 835831 removable, 972662 nonremovable row
> > versions in 2890304 pages
> Oy, that's one bloated table ... only
On Wed, Mar 28, 2007 at 12:10:27PM -0400, Tom Lane wrote:
> Stephen Harris <[EMAIL PROTECTED]> writes:
> > It's vacuumed every night after the updates. There are minimal (zero,
> > most days) updates during the day. As I mentioned earlier, nightly we do:
>
&g
On Wed, Mar 28, 2007 at 11:36:27AM -0400, Tom Lane wrote:
> Stephen Harris <[EMAIL PROTECTED]> writes:
> > INFO: "sweep_users": found 835831 removable, 972662 nonremovable row
> > versions in 2890304 pages
> > DETAIL: 0 dead row versions cannot be removed
On Wed, Mar 28, 2007 at 11:07:54AM -0400, Tom Lane wrote:
> Stephen Harris <[EMAIL PROTECTED]> writes:
> > I have one specific table ("sweep_users") that has 900,000 rows in prod
> > and 630,000 on the standby. On the standby a "select count(*) from
> > s
This 8.0.8 on Solaris 8. Yes I know; old technologies but we can't
upgrade yet.
I have two identical servers. One is production and overnight we do
a complete dump and scp the results to the other. The other is standby.
It's currently running data that's about 7 months old because we haven't
n
On Thu, Dec 07, 2006 at 08:54:22AM -0600, andy rost wrote:
> Is there any documentation on the output from pg_controldata? Most of it
> seems intuitive but I would like something definitive on the following
> lines:
>
> Latest checkpoint location: 2F9/B38DE758
> Prior checkpoint location:
I didn't see this mentioned in the INSTALL or doc/ directory, so...
I have versions of SSL libraries in my own directories and so used
a command line such as:
./configure --prefix=/local/apps/postgres/8.2.rc1.0 \
--exec-prefix=/local/apps/postgres/8.2.rc1.0/linux \
This is probably a silly question, but are the database files binary portable?
eg could I take datafiles from a Sparc and copy them to an Intel machine,
or would the endianness differences kill me?
I expect the answer to be "funny man! Of course not!" for reasons of speed
(native interger handlin
On Sat, Nov 25, 2006 at 04:23:10PM -0500, Tom Lane wrote:
> I'd advise you to be using a 2.6 kernel at this point, too. I don't
> know what the Centos guys have in mind as a schedule for releasing
> a 2.6-based distro, but again Fedora is at least as good a bet if you
> want a Red Hat based distro
On Fri, Nov 17, 2006 at 09:39:39PM -0500, Gregory Stark wrote:
> "Stephen Harris" <[EMAIL PROTECTED]> writes:
> > [...variable setup...]
> > while [ ! -f $wanted_file ]
> > do
> > if [ -f $abort_file ]
> > then
> >
On Fri, Nov 17, 2006 at 05:03:44PM -0500, Tom Lane wrote:
> Stephen Harris <[EMAIL PROTECTED]> writes:
> > Doing a shutdown "immediate" isn't to clever because it actually leaves
> > the recovery threads running
>
> > LOG: restored log file &q
I'm using 8.2beta3 but I'm asking here before posting to the devel
lists as suggested by that lists guidelines..
First the question, because it might be simple and I'm stupid. However
I'll then go into detail in case I'm not so silly.
In a database which is in recovery mode waiting on an externa
15 matches
Mail list logo
