yes, vacuum analyze is used constantly.
--Ben
--- Fernando Schapachnik <[EMAIL PROTECTED]>
> wrote:
>Have you vacuum analyzed after the restore?
>
>En un mensaje anterior, Benjamin Franks escribi=F3:
>> I have a dual-CPU (PIII 600MHz), 512MB, IDE-HD box. A couple of months a=
>go I was using Lin
"Alastair D'Silva" <[EMAIL PROTECTED]> writes:
> I've recently upgraded to 7.1 and have the following situation which no
> longer works:
> As user "nmnadmin":
> CREATE TABLE blah {
> id NOT NULL SERIAL,
> info text NOT NULL
> };
> GRANT SELECT, INSERT, UPDATE, DELETE ON blah TO nmn
"Alastair D'Silva" wrote:
>I've recently upgraded to 7.1 and have the following situation which no
>longer works:
...
>As user "nmnuser":
>
>INSERT INTO blah (info) VALUES ('foo');
>
>
>
>I get the following error:
>blah_id_seq.nextval: you don't have permissions to set sequen
Title: RE: [GENERAL] PostGreSql 7.1
http://www.postgresql.org/sites.html has a list of mirrors try one of them near you and the RPMs should be in directory dev/test-rpms
Regards
Ben
> -Original Message-
> From: Jack [mailto:[EMAIL PROTECTED]]
> Sent: 30 March 2001 0
On Friday, March, 2001-03-30 at 13:13:56, Jack wrote:
> Hi, All
>
> Where can I get a PostGreSQL 7.1 lattest beta version with RPM installation?
maybe ftp://ftp.postgresql.org/pub/dev/test-rpms/
I don't know, I've never tried them (using RH I prefer own compilation).
regards
--
Marek Pętlick
[EMAIL PROTECTED] writes:
> Any thoughts what may have casued this?
Not from that amount of data. Are there any core-dump files laying
about?
regards, tom lane
---(end of broadcast)---
TIP 1: subscribe and unsubscribe comm
ow to procceed?
TIA,
Paulo Parola
[EMAIL PROTECTED]
- Original Message -
From: Mirko Zeibig <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, February 22, 2001 7:20 PM
Subject: Re: [GENERAL] PostgreSQL 7.1 Linux Installation
> On Thu, Feb 22, 2001 at 04:07:06PM -
Insurance Company
- Original Message -
From: "Robert D. Nelson" <[EMAIL PROTECTED]>
To: "Adam Lang" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, October 12, 2000 3:10 PM
Subject: RE: [GENERAL] postgresql 7.1
> >For prohjects such
>For prohjects such as this that have commercial documentation, why don't
>they have "patches" for printed books also?
...
>It would be an interesting documentation project that would really keep
>information organized and relatively accessible ('cause sometimes digging
>through webpages and email
So a new version will be out soon. How often Bruce's book will be revised?
With each new version?
- Original Message -
From: "Tim Uckun" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, October 12, 2000 5:43 AM
Subject: Re: [GENERAL] postgresql 7.1
At 01:37 AM 10/12/2000 -0400, Tom Lane wrote:
>Tim Uckun <[EMAIL PROTECTED]> writes:
> > What happened to outer joins? Don't you need outer joins to compete with
> > the big boys?
>
>They're done too ;-)
Wooo Hooo time to break out the champagne!
--
Tim Uckun <[EMAIL PROTECTED]> writes:
> What happened to outer joins? Don't you need outer joins to compete with
> the big boys?
They're done too ;-)
regards, tom lane
On Wed, 11 Oct 2000, Tim Uckun wrote:
> At 11:04 PM 10/11/2000 -0300, Martin A. Marques wrote:
> >On Wed, 11 Oct 2000, Asidha Luhwidyanto wrote:
> > > What;s the new in Postgresql 7.1 ?
> >
> >TOAST and WAL
> >
> >I think these are big changes that will make me think about postgresql as a
> >
At 11:04 PM 10/11/2000 -0300, Martin A. Marques wrote:
>On Wed, 11 Oct 2000, Asidha Luhwidyanto wrote:
> > What;s the new in Postgresql 7.1 ?
>
>TOAST and WAL
>
>I think these are big changes that will make me think about postgresql as a
>big time competitor against the big commercial database
* Martin A. Marques <[EMAIL PROTECTED]> [001011 19:10] wrote:
> On Wed, 11 Oct 2000, Asidha Luhwidyanto wrote:
> > What;s the new in Postgresql 7.1 ?
>
> TOAST and WAL
>
> I think these are big changes that will make me think about postgresql as a
> big time competitor against the big comme
On Wed, 11 Oct 2000, Asidha Luhwidyanto wrote:
> What;s the new in Postgresql 7.1 ?
TOAST and WAL
I think these are big changes that will make me think about postgresql as a
big time competitor against the big commercial database engines.
WAL is a backup system.
TOAST is a system for worki
What;s the new in Postgresql 7.1 ?
Asidha Luhwidyanto
"Martin A. Marques" wrote:
> How far are we from seeing the version 7.1 out?
>
> --
> "And I'm happy, because you make me feel good, about me." - Melvin Udall
> -
> Martín Marq
On Wed, 11 Oct 2000, Martin A. Marques wrote:
> How far are we from seeing the version 7.1 out?
beta starts ~Nov 1st, release in January ...
Mitch Vincent wrote:
> I was sitting here reading about TOAST and 7.1 and another question came
> into my mind.. I looked on the web page for some information about features
> to be added in 7.1 and an approximate 7.1 release date.. I found information
> on the TOAST feature as well as Referential
"Mitch Vincent" <[EMAIL PROTECTED]> writes:
> I was sitting here reading about TOAST and 7.1 and another question came
> into my mind.. I looked on the web page for some information about features
> to be added in 7.1 and an approximate 7.1 release date.. I found information
> on the TOAST feature
20 matches
Mail list logo
