2012/5/25 Raghavendra :
>> >
>> > http://postgres.cz/wiki/Enhanced-psql
>> >
>> > Is this also compatible to 9.1 ?
>> >
>>
>> no, this was prepared for 8.4. These features was just experiment and
>> only smaller subset is in core now.
>>
>
> Oh ok. Thank you for the info.
>
> Multi-Headers, Macros
>
> >
> > http://postgres.cz/wiki/Enhanced-psql
> >
> > Is this also compatible to 9.1 ?
> >
>
> no, this was prepared for 8.4. These features was just experiment and
> only smaller subset is in core now.
>
>
Oh ok. Thank you for the info.
Multi-Headers, Macros of psql 8.4 were very interesting fe
On Wed, May 16, 2012 at 01:27:18PM +0200, Christian J. Dietrich wrote:
>
> Hey all,
>
> I have a problem which I speculate to be due to the pg_upgrade bug [1]:
>
> ERROR: could not access status of transaction 13636
> DETAIL: could not open file "pg_clog/": No such file or directory
>
> The
On Wed, May 16, 2012 at 10:08:03AM +0100, Raymond O'Donnell wrote:
> On 15/05/2012 22:50, Scott Briggs wrote:
> > So this is purely anecdotal but I'm curious, what's with all the
> > different naming conventions? There's psql (for database
> > connections), pgsql (used for some dirs like /usr/pgsq
2012/5/24 Raghavendra :
>> hello
>> I wrote patch for PostgreSQL 9.1 and 9.2 that adds more linestyles and
>> border styles to console
>> http://postgres.cz/wiki/Pretty_borders_in_psql
>
>
> Thank you. And really a great patch to psql console lover's... :)
>
> http://postgres.cz/wiki/Enhanced-psql
We have lots of partition tables that inherit
from a smaller number of parents. Some,
but not all of these tables also have indexes.
The number actually varies depending on
the data loaded. For some other database
instances, fortunately on Linux, the number
is in the millions.
I have been test
Tom Lane writes:
> [...] Can you correlate the performance hit with any specific part
> of autovacuum? In particular, I'm wondering if it matters whether
> vacuum is cleaning tables or indexes [...]
In case it helps, this systemtap run will report on the top few
time-sampled call graphs of pos
Lonni J Friedman writes:
> On Thu, May 24, 2012 at 12:34 PM, Tom Lane wrote:
>> Can you correlate the performance hit with any specific part of
>> autovacuum? In particular, I'm wondering if it matters whether vacuum
>> is cleaning tables or indexes --- it alternates between the two, and the
>> a
On Thu, May 24, 2012 at 12:34 PM, Tom Lane wrote:
> Lonni J Friedman writes:
>> No, not lots of subqueries or ORDERing, and most queries only touch a
>> single table. However, I'm honestly not sure that I'm following where
>> you're going with this. The problem isn't triggered by explicit
>> q
Lonni J Friedman writes:
> No, not lots of subqueries or ORDERing, and most queries only touch a
> single table. However, I'm honestly not sure that I'm following where
> you're going with this. The problem isn't triggered by explicit
> queries. I can disable all external access, and simply wa
On Wed, May 23, 2012 at 2:45 PM, Gavin Flower
wrote:
> On 24/05/12 08:18, Lonni J Friedman wrote:
>
> On Wed, May 23, 2012 at 12:36 PM, Gavin Flower
> wrote:
>
> On 24/05/12 05:09, Lonni J Friedman wrote:
>
> On Wed, May 23, 2012 at 9:37 AM, Tom Lane wrote:
>
> Lonni J Friedman writes:
>
> Afte
>
> hello
> I wrote patch for PostgreSQL 9.1 and 9.2 that adds more linestyles and
> border styles to console
> http://postgres.cz/wiki/Pretty_borders_in_psql
Thank you. And really a great patch to psql console lover's... :)
http://postgres.cz/wiki/Enhanced-psql
Is this also compatible to 9.1 ?
2012/5/24 Alban Hertroys :
> On 24 May 2012 15:33, Pavel Stehule wrote:
>> hello
>>
>> I wrote patch for PostgreSQL 9.1 and 9.2 that adds more linestyles and
>> border styles to console
>
> Nice job!
Thank you :)
> I'm not entirely enthusiastic about the option names though. Would it
> help to s
On 24 May 2012 15:33, Pavel Stehule wrote:
> hello
>
> I wrote patch for PostgreSQL 9.1 and 9.2 that adds more linestyles and
> border styles to console
Nice job!
I'm not entirely enthusiastic about the option names though. Would it
help to split the setting into several?
For example:
\pset bord
hello
I wrote patch for PostgreSQL 9.1 and 9.2 that adds more linestyles and
border styles to console
http://postgres.cz/wiki/Pretty_borders_in_psql
Regards
Pavel Stehule
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.pos
On Thu, May 24, 2012 at 2:42 AM, Mark Dilger wrote:
> FindFirstFile can take a wildcard filename
> pattern. It appears that we are effectively
> calling FindFirstFile without a pattern, getting
> all 56000 file names with complete stat
> information, doing a poor-man's regex on
> those names, and
On Thu, May 24, 2012 at 12:47 AM, Mark Dilger wrote:
> I am running this code on Windows 2003. It
> appears that postgres has in src/port/dirent.c
> a port of readdir() that internally uses the
> WIN32_FIND_DATA structure, and the function
> FindNextFile() to iterate through the directory.
> Look
I have observed by default posgresql 8.x onwards starts as daemon process.
Is there a way to avoid it. I want it to run as normal process. The parent
of the server process should be the process that starts the server instead
of being PID 1 ( init ). Till 7.4.2 ( Which was the older version used by
On Wed, May 23, 2012 at 5:11 PM, Herouth Maoz wrote:
> A replication solution is not very good, either, because of course I can't
> define indexes differently, I don't want *all* transactions in all tables to
> be sent, and also, because I may want to cross reference data from different
> syste
19 matches
Mail list logo
