On Mon, Jan 26, 2009 at 12:06 AM, Phoenix Kiula wrote:
> On Mon, Jan 26, 2009 at 3:04 PM, Scott Marlowe
> wrote:
>> On Sun, Jan 25, 2009 at 11:58 PM, Phoenix Kiula
>> wrote:
>>> Hi Scott. Yes, there is an autovacuum on both the tables. Should i
>>> additionally do a manual vacuum too?
>>
>> Na
On Mon, Jan 26, 2009 at 3:04 PM, Scott Marlowe wrote:
> On Sun, Jan 25, 2009 at 11:58 PM, Phoenix Kiula
> wrote:
>> Hi Scott. Yes, there is an autovacuum on both the tables. Should i
>> additionally do a manual vacuum too?
>
> Nah, just an analyze. what version of pgsql is this, btw?
>
Actual
On Sun, Jan 25, 2009 at 11:58 PM, Phoenix Kiula wrote:
> Hi Scott. Yes, there is an autovacuum on both the tables. Should i
> additionally do a manual vacuum too?
Nah, just an analyze. what version of pgsql is this, btw?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To
On Mon, Jan 26, 2009 at 2:26 PM, Scott Marlowe wrote:
> On Sun, Jan 25, 2009 at 8:41 PM, Phoenix Kiula
> wrote:
>
>> My query is:
>>
>>
>> explain analyze SELECT
>>testimonials.url
>>,testimonials.alias
>>,testimonials.aliasEntered
>>,testimonials.
On Sun, Jan 25, 2009 at 8:41 PM, Phoenix Kiula wrote:
> My query is:
>
>
> explain analyze SELECT
>testimonials.url
>,testimonials.alias
>,testimonials.aliasEntered
>,testimonials.title
>,testimonials.modify_date
>,testimonia
Hope someone can shed light on this.
I have a well-performing query that uses the index. Without OFFSET etc
it returns about 11,000 records.
I only need about 20 of these records at any given time, which is why
my LIMIT and OFFSET try to pull only the 20 records or so.
My queries are fast in gen
On 01/24/2009 12:42 AM, Richard Huxton wrote:
> Clemens Schwaighofer wrote:
>> On 01/22/2009 07:11 PM, Richard Huxton wrote:
>>> Clemens Schwaighofer wrote:
Hi,
I just literally trashed my test server with one delete statement
because the psql used up all its memory and started
Raymond O'Donnell wrote on 25.01.2009 19:28:
For WindowsXP the above command can be written as:
tasklist /v /fi "imagename eq postgres.exe"
Cool! I didn't know that one. Must R some more FMs :-)
No need for manuals :)
Just enter "takslist /?"
Regards
Thomas
--
Sent via pgsql-general
On 25/01/2009 13:37, Thomas Kellerer wrote:
> Abdul Rahman wrote on 22.01.2009 07:06:
>> Now, kindly let me know the detail about the solution send by Ray, i.e.
>>
>> ps ax | grep postgres
>
> For WindowsXP the above command can be written as:
>
> tasklist /v /fi "imagename eq postgres.exe"
Cool
On Sun, 25 Jan 2009, Thomas Kellerer wrote:
> Hi,
>
> I'm playing around with deferred constraints and according to the manual, it
> should be possible to declare a check constraint as deferred.
>
> At least that's how I read the definition of /column_constraint/ at
> http://www.postgresql.org/do
On Sun, Jan 25, 2009 at 05:08:54PM +0100, Martijn van Oosterhout wrote:
> On Sun, Jan 25, 2009 at 03:52:02PM +, Roger Leigh wrote:
> >
> > I'm duplicating text* to char* by hand.
> > Is the text_to_cstring available internally also accessible by
> > external modules (I didn't see it in any hea
Osvaldo Kussama wrote on 25.01.2009 15:24:
See the manual:
http://www.postgresql.org/docs/current/interactive/sql-createtable.html
"DEFERRABLE
NOT DEFERRABLE
This controls whether the constraint can be deferred. A constraint
that is not deferrable will be checked immediately after every
comm
On Sun, Jan 25, 2009 at 03:52:02PM +, Roger Leigh wrote:
> Many thanks for this suggestion; it has been incredibly useful.
No problem.
> I just have a few points I'd like to clarify. In
>
>
> http://git.debian.org/?p=users/rleigh/sbuild.git;a=blob;f=db/debversion.cc;h=980786ecf7a3b7fb576
On Wed, Jan 21, 2009 at 08:52:19PM +0100, Martijn van Oosterhout wrote:
> On Wed, Jan 21, 2009 at 10:48:09AM +, Roger Leigh wrote:
> > Ah, thanks for the clarification. So I need to use CREATE TYPE
> > rather than CREATE DOMAIN. Because I'm essentially just storing
> > a text string with diff
2009/1/25, Thomas Kellerer :
> Hi,
>
> I'm playing around with deferred constraints and according to the manual, it
> should be possible to declare a check constraint as deferred.
>
> At least that's how I read the definition of /column_constraint/ at
> http://www.postgresql.org/docs/8.3/static/sql
Hello,
Here's a step-by-step guide to building the PostgreSQL manual in Info
format on a Debian Lenny box:
First of all, you may made need to install a few extra packages:
$ sudo apt-get install bzip2 docbook-dsssl docbook2x opensp
Next, download the PostgreSQL source (using apt), unpack it a
Abdul Rahman wrote on 22.01.2009 07:06:
Now, kindly let me know the detail about the solution send by Ray, i.e.
ps ax | grep postgres
For WindowsXP the above command can be written as:
tasklist /v /fi "imagename eq postgres.exe"
Thomas
--
Sent via pgsql-general mailing list (pgsql-general
Hi,
I'm playing around with deferred constraints and according to the manual, it
should be possible to declare a check constraint as deferred.
At least that's how I read the definition of /column_constraint/ at
http://www.postgresql.org/docs/8.3/static/sql-createtable.html
What I tried:
CR
18 matches
Mail list logo
