Hi,
Thanks for the reply and advice.
Scott Marlowe kirjoitti:
Version : 8.1.11Vendor: CentOS
So, you built it its own machine, but you didn't upgrade to at least 8.2?
Now it is: 8.4devel_15092008
The machine was installed by the production team from
Hi,
We just upgraded Best Practical's RT from 3.6 to 3.81 and gave the
database completely own machine. And the users still complain that it is
dog slow. :-( I installed pg_top and it seems that at the beginning of
the ticket display RT-issues a query that eats everything the database
has. Query i
Robert Treat wrote:
>On Friday 09 September 2005 09:20, Mauri Sahlberg wrote:
>
>
>>Hi,
>>
>>I have found myself in a situation where I need to quickly delete rows
>>from a production database. Unfortunately table for the rows to be
>>deleted have trigger
Hi,
I have found myself in a situation where I need to quickly delete rows
from a production database. Unfortunately table for the rows to be
deleted have triggers which results massive chain of update operations
on other tables. I do not wish those to happen as I'm about to delete
concerned rows
ma, 2005-05-02 kello 10:52 -0400, Tom Lane kirjoitti:
> Mauri Sahlberg <[EMAIL PROTECTED]> writes:
> > I'm starting to become desperate. On saturday I dumped all databases,
> > wiped whole postgresql installation. Installed newest rpms for Fedora 1,
> > resto
Hi,
I'm starting to become desperate. On saturday I dumped all databases,
wiped whole postgresql installation. Installed newest rpms for Fedora 1,
restored databases. Recompiled client libraries and binaries. Restarted
and after five hours of operation:
May 1 21:34:19 claymountain postgres[6337]:
hadow and pg_group that are
related to the database in question and insert them in the new
environment? (The rows to use could probably be deducted from other
catalog tables and views by queries...)
Regards,
Mauri Sahlberg
---(end of broadcast)---
Hi,
Ian Westmacott wrote:
>Mauri, I'm no expert but I can tell you what I know. We
>have experienced this same problem, and I asked a
>similar question not too long ago.
>
>- This is probably due to some sort of I/O problem. In
> our case, it occurs very frequently on reboots, and
> it app
of the four serendipity databases we have, I do not yet
know which one
Apr 28 08:46:45 claymountain postgres[14998]: [3-2] DETAIL: could not
open file "/var/lib/pgsql/data/pg_clog/": No such file or directory
Regards,
Mauri Sahlberg
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
Hi,
What an earth I am doing wrong? I am trying to delete about 6500 rows and
I am the only user connected to the database and it just sits there and
does nothing?
Jun 9 10:02:44 pihsi postgres[31547]: [25] LOG: query: begin;
Jun 9 10:02:44 pihsi postgres[31547]: [26] LOG: duration: 0.000181
Hi,
What an earth I am doing wrong? I am trying to delete about 6500 rows and
I am the only user connected to the database and it just sits there and
does nothing?
rahaks=# select count(*) from tilikartta where yritys=18231413;
count
---
6347
(1 row)
rahaks=# explain delete from tilikartt
su, 2004-01-25 kello 23:08, Tom Lane kirjoitti:
> Mauri Sahlberg <[EMAIL PROTECTED]> writes:
> > The framework is that a c++ application transforms xml-input data to
> > sql-procedure calls with appropriate parameters who in turn call another
> > procedures who in t
uggestions?
Regards,
--
Mauri Sahlberg <[EMAIL PROTECTED]>
Claymountain Solutions Oy
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
purpose.
My solution is to keep the diagrams updated so that I don't need reverse
engineering. ;)
Regards,
--
Mauri Sahlberg <[EMAIL PROTECTED]>
Claymountain Solutions Oy
---(end of broadcast)---
TIP 3: if posting/reading through Usene
both of my questions have
been kind of RTFM questions, had I just thought them out!
The only two places I've got answers so fast have been Datavision and
Inetd-software.
> Mauri Sahlberg <[EMAIL PROTECTED]> writes:
>> If the following is executed in context, where the dynamic qu
Hi,
This time I think this is a bug, but where? In my code or in plpgsql? Or
in my understanding of dynamic queries?
If the following is executed in context, where the dynamic query returns
data with every iteration everythin goes fine. If the the dynamic query
returns nothing - bush becomes null
On pe, 2003-08-01 at 03:12, Stephan Szabo wrote:
> > interface. If we run them one by one everything goes fine. But if I
> > run them in parallel - in separate processes - all but the first one
> > claiming the lock for "ryhmalaiset"-table will fail. And they will
> > fail as soon as the first one
On pe, 2003-08-01 at 09:21, Stephan Szabo wrote:
> On 1 Aug 2003, Mauri Sahlberg wrote:
>
> > On pe, 2003-08-01 at 08:51, Stephan Szabo wrote:
> > > On 1 Aug 2003, Mauri Sahlberg wrote:
> > >
> > > > On pe, 2003-08-01 at 03:12, Stephan Szabo wrote:
> &
On pe, 2003-08-01 at 08:51, Stephan Szabo wrote:
> On 1 Aug 2003, Mauri Sahlberg wrote:
>
> > On pe, 2003-08-01 at 03:12, Stephan Szabo wrote:
> > > > interface. If we run them one by one everything goes fine. But if I
> > > > run them in parallel - in separa
On pe, 2003-08-01 at 03:12, Stephan Szabo wrote:
> > interface. If we run them one by one everything goes fine. But if I
> > run them in parallel - in separate processes - all but the first one
> > claiming the lock for "ryhmalaiset"-table will fail. And they will
> > fail as soon as the first one
Hi,
Either we have found a bug in Postgres (which I seriously doubt) or we
are being stupid clever enough way to not notice it.
We have five complex "transactions" that are executed thru pq++/c++
interface. If we run them one by one everything goes fine. But if I
run them in parallel - in separat
On su, 2003-01-26 at 03:03, Bruce Momjian wrote:
> Uh, you can turn on log_statements in postgresql.conf and they will
> appear in the server logs.
>
> ---
>
Logging options are explained in the Administrator's manual at cha
22 matches
Mail list logo