sorry, forgot to cc: to the group..To: Alvaro Herrera <
[EMAIL PROTECTED]>
not as far as I can tell... I have log_destination='stderr'. unless csv
logging is enabled in another location?
Since I disabled the following line:
shared_preload_libraries = '$libdir/plugins/plugin_debugger.dll'
an
Thanks all, option 2 seems to work for me, just wanted to be sure I
wasn't asking for crashes.
Oliver Kohll
On 8 Jun 2008, at 18:01, Tom Lane wrote:
Oliver Kohll <[EMAIL PROTECTED]> writes:
What I've thought of trying so far is
1) creating a symlink called libpq.so.4 towards libpq.so.5 - sl
Peter Eisentraut <[EMAIL PROTECTED]> writes:
> A workable fix, at least from the point of view of a Debian developer, is to
> put the soname number into the package name (libpq3, libpq4, libpq5, etc.),
> thus making them unique and coinstallable for all times.
FWIW, the package names Red Hat has
Hi,
On Sun, 2008-06-08 at 11:55 +0100, Oliver Kohll wrote:
> 3) building a custom compat package - I don't know how to do this
> though.
These are probably my packages from http://yum.pgsqlrpms.org , and I
thought I already fixed this issue -- I'll check.
Anyway,
http://yum.pgsqlrpms.org/8.3
> I have a query that takes 2 sec if I run it from a freshly restored dump.
> If I run a full vacuum on the database it then takes 30 seconds.
What do the two plans look like? Can you post the explains?
-Nathan
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make chang
Am Sunday, 8. June 2008 schrieb Albe Laurenz:
> > In short, I've upgraded to 8.3.1 from 8.1 on RHEL 4 (with
> > some CentOS packages). I have apps with dependencies of
> > libpq.so.4 but this is no longer available. 8.3.1 provides
> > libpq.so.5 and the compat-libs provide libpq.so.3.
>
> Strange;
Oliver Kohll wrote:
> I have the same issue as this poster with libpq.so.4:
> http://www.nabble.com/8.3.0-upgrade-td16093803.html
>
> In short, I've upgraded to 8.3.1 from 8.1 on RHEL 4 (with
> some CentOS packages). I have apps with dependencies of
> libpq.so.4 but this is no longer available.
Jaime Casanova escribió:
> if i mark the index not ready (using pg_index.indisvalid or
> pg_index.indisready depending on version), will the index be updated
> if in another transaction i make an insert?
Yes (in fact that's the whole point of having an index marked "not
valid/ready").
--
Alvaro
On Sun, Jun 8, 2008 at 11:45 AM, Tom Lane <[EMAIL PROTECTED]> wrote:
> Viktor Rosenfeld <[EMAIL PROTECTED]> writes:
>> That works, but I'm still looking for another way to deactivate the
>> index. The reason being, that my query load is randomly generated by
>> a Java program and I don't want to g
Oliver Kohll <[EMAIL PROTECTED]> writes:
> What I've thought of trying so far is
> 1) creating a symlink called libpq.so.4 towards libpq.so.5 - slightly
> dangerous due to possible API changes?
Worth trying. According to the CVS logs
http://archives.postgresql.org/pgsql-committers/2006-04/msg00
Viktor Rosenfeld <[EMAIL PROTECTED]> writes:
> That works, but I'm still looking for another way to deactivate the
> index. The reason being, that my query load is randomly generated by
> a Java program and I don't want to go and change the SQL compiler.
Well, you're going to have to change *
Charles F. Munat wrote:
Thanks, but the join clause is there, it's just buried in the subqueries.
If there is a problem, it is probably that the loop never ends.
Or it could be that the answer is exponential, and I just have too many
rows in the source table and too deep a graph.
I figured o
On Sun, Jun 8, 2008 at 7:55 AM, Jaime Casanova <[EMAIL PROTECTED]> wrote:
> On Sun, Jun 8, 2008 at 1:34 AM, Scott Marlowe <[EMAIL PROTECTED]> wrote:
>> On Sat, Jun 7, 2008 at 5:16 PM, Viktor Rosenfeld
>> <[EMAIL PROTECTED]> wrote:
Try this:
begin;
drop indexname;
expla
On Sun, Jun 8, 2008 at 1:34 AM, Scott Marlowe <[EMAIL PROTECTED]> wrote:
> On Sat, Jun 7, 2008 at 5:16 PM, Viktor Rosenfeld
> <[EMAIL PROTECTED]> wrote:
>>>
>>> Try this:
>>>
>>> begin;
>>> drop indexname;
>>> explain analyze select ...;
>>> rollback;
>>
>> That works, but I'm still looking for ano
Hello,
I have the same issue as this poster with libpq.so.4:
http://www.nabble.com/8.3.0-upgrade-td16093803.html
In short, I've upgraded to 8.3.1 from 8.1 on RHEL 4 (with some CentOS
packages). I have apps with dependencies of libpq.so.4 but this is no
longer available. 8.3.1 provides libpq.
On Sat, Jun 7, 2008 at 8:07 PM, Jeremy Harris <[EMAIL PROTECTED]> wrote:
> Gregory Stark wrote:
>
>> REINDEX scans the table
>> precisely once and sorts it.
>>
>
> For the bloat, as opposed to corruption, case -
> what information is needed from the table that
> is not in the old index? Why woul
16 matches
Mail list logo