Hi
2005-06-16 23:22:20 LOG: 0: checkpoints are occurring too
frequently (1 seconds apart)
HINT: Consider increasing the configuration parameter "checkpoint_segments".
Is this bad on the hard disk ?. or on the postgresql server?.
Can i change the checkpoints which is currently 10 to sometin
On Thu, Jun 16, 2005 at 12:08:35AM -0400, Tom Lane wrote:
> David <[EMAIL PROTECTED]> writes:
> > Well, you guessed correctly. It was a configuration problem. By
> > inserting the line:
> > unix_socket_directory = '/var/run/postgresql'
> > into postgresql.conf, it works as expected.
>
>
Hi Adrian!
Yes, the user have to wait until the refresh finishes... That's a
problem but we didn't found any other solution...
Regards,
Rodrigo Carvalhaes
Din Adrian wrote:
I am sorry - I don't understand (or my english is bad or I don't
know what you mean).
What we did was include one
On Thu, 2005-06-16 at 09:35, Francesco Dalla Ca' wrote:
> O.S.:
> SuSE SLES-8 (i386)
> VERSION = 8.1
>
> After some test with the "syncbench" posted on performance mailing-list
> (http://archives.postgresql.org/pgsql-performance/2004-09/msg00080.php)
> i have obtained that open() with O_DSYNC was
O.S.:
SuSE SLES-8 (i386)
VERSION = 8.1
After some test with the "syncbench" posted on performance mailing-list
(http://archives.postgresql.org/pgsql-performance/2004-09/msg00080.php)
i have obtained that open() with O_DSYNC was the fastest sync method.
I want to test this for parameter "wal_syn
I am sorry - I don't understand (or my english is bad or I don't know
what you mean).
What we did was include one "refresh" button and inserted one
configuration that after x seconds the component refresh the screen
(query).
So:
When the user push the 'post' button the driver automatical
Hi Adrian,
You're right. What we did was include one "refresh" button and inserted
one configuration that after x seconds the component refresh the screen
(query).
If you find a better solution, please inform me.
Regards,
Rodrigo
Din Adrian wrote:
We tested also (pgExpress Driver) - is fa
Tom Lane wrote:
I'm suspicious of a more subtle intermittent error.
Yeah, I am too, but so far none of the reporters have been cooperative
about providing more information :-(
Well, at least from me, I can tell you I gave all information I came up
with. One thing that I pointed out is this
We tested also (pgExpress Driver) - is faster then psqlodbc but we have a
problem with it:
it does requery (or refresh? - I don't remember exactly) after every post
in database.(for us this is a problem - if you have more then 10.000 in
current dataset loaded when you add a new record and pos
Hi J!
We use here vitavoom from Steve Howe (www.vitavoom.com). It's a very
good and native alternative.
It's paid but not expensive and you will have a very good and qualified
technical supporte.
Regards,
Rodrigo Carvalhaes
Postgres Admin wrote:
I have a client who wants to use Delphi as
Bill Hernandez <[EMAIL PROTECTED]> writes:
> SERVER_ADDR ::1
> REMOTE_ADDR ::1
> I have no clue where the "::1" is coming from ?
Looks perfectly fine to me; that's the usual IPv6 notation for "local
loopback connection", AFAIK. If your client code cannot cope with IPv
Simon Riggs <[EMAIL PROTECTED]> writes:
> I'm suspicious of a more subtle intermittent error.
Yeah, I am too, but so far none of the reporters have been cooperative
about providing more information :-(
> We have no
> information about what the magic values are, only that they are not
> correct. S
::1 is a function of the PHP $_SERVER[''] internal function, not a
PostgreSQL problem. It will display ::1 on any database, you program a
PHP custom function to call the whole IP address. The real question is
that a problem in a production environment? Of note, outside IP
addresses will display fi
On Fri, 2005-06-10 at 12:57 -0400, Tom Lane wrote:
> "Bruno G. Albuquerque" <[EMAIL PROTECTED]> writes:
> > Any pointers? Is there anything I can do for Windows to actually wait
> > for the postgresql processes to clean up?
>
> What it looks like to me is that your disk drive is lying about what
we are using postgresql8 +psqlodbc8+ delphi7 ... the only problem is the
server side cursor = doesn't work properly ... so we are using client side
for datasets :)
On Wed, 15 Jun 2005 23:49:29 -0400, Postgres Admin
<[EMAIL PROTECTED]> wrote:
I have a client who wants to use Delphi
15 matches
Mail list logo
