Ron Johnson wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 10/18/06 20:41, andrew plata wrote:
I am trying to following the instructions at URL below to try to create a
database called web_database required for phpPgAdmin. When I try to do this
I get the following error:
template1=# c
Ron Johnson wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 10/19/06 00:46, Rick Gigger wrote:
Ron Johnson wrote:
On 10/18/06 23:52, Rick Gigger wrote:
Rick Gigger wrote:
Ron Johnson wrote:
On 10/18/06 19:57, Rick Gigger wrote:
[snip]
Not much that is useful. I think this is a li
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 10/19/06 00:46, Rick Gigger wrote:
> Ron Johnson wrote:
>>
>> On 10/18/06 23:52, Rick Gigger wrote:
>>> Rick Gigger wrote:
Ron Johnson wrote:
>
> On 10/18/06 19:57, Rick Gigger wrote:
[snip]
> Not much that is useful. I think this is a
Ron Johnson wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 10/18/06 23:52, Rick Gigger wrote:
Rick Gigger wrote:
Ron Johnson wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 10/18/06 19:57, Rick Gigger wrote:
To make a long story short lets just say that I had a bit of a har
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 10/18/06 23:58, Sandeep Kumar Jakkaraju wrote:
> Is it possible to port from Postgres tables to Versant
Anything is possible, given enough time, money.
Your design skills plus the complexity of the objects and current
schema design will determine
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 10/18/06 23:52, Rick Gigger wrote:
> Rick Gigger wrote:
>> Ron Johnson wrote:
>>> -BEGIN PGP SIGNED MESSAGE-
>>> Hash: SHA1
>>>
>>> On 10/18/06 19:57, Rick Gigger wrote:
To make a long story short lets just say that I had a bit of a har
Is it possible to port from Postgres tables to Versant
-
sandeep
Rick Gigger wrote:
Ron Johnson wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 10/18/06 19:57, Rick Gigger wrote:
To make a long story short lets just say that I had a bit of a hardware
failure recently.
If I got an error like this when trying to dump a db from the mangled
data direct
Ron Johnson wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 10/18/06 19:57, Rick Gigger wrote:
To make a long story short lets just say that I had a bit of a hardware
failure recently.
If I got an error like this when trying to dump a db from the mangled
data directory is it safe to sa
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 10/18/06 20:47, Robert Treat wrote:
> On Wednesday 18 October 2006 01:47, louis gonzales wrote:
>> Is your server capable? Does it have enough resources to handle many
>> connections?
>>
>> many = ??? 100, 200, 1,000,000,000 are they concu
On Tuesday 17 October 2006 05:36, A. Kretschmer wrote:
> am Tue, dem 17.10.2006, um 10:44:52 +0200 mailte Thomas Kellerer folgendes:
> > On 17.10.2006 10:36 Andreas Kretschmer wrote:
> > >http://techdocs.postgresql.org/#convertfrom
> >
> > I just noticed that the link "Porting from Oracle PL/SQL"
On Wednesday 18 October 2006 01:47, louis gonzales wrote:
> Is your server capable? Does it have enough resources to handle many
> connections?
>
> many = ??? 100, 200, 1,000,000,000 are they concurrent users?
>
> 'good for large applications' = ??? I'd say, how large your
> applicati
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 10/18/06 20:41, andrew plata wrote:
> I am trying to following the instructions at URL below to try to create a
> database called web_database required for phpPgAdmin. When I try to do this
> I get the following error:
>
> template1=# create databa
andrew plata wrote:
I am trying to following the instructions at URL below to try to create
a database called web_database required for phpPgAdmin. When I try to do
this I get the following error:
template1=# create database web_database owner web_user;
ERROR: could not write to file "base/16
I am trying to following the instructions at URL below to try to create a database called web_database required for phpPgAdmin. When I try to do this I get the following error:template1=# create database web_database owner web_user;
ERROR: could not write to file "base/16390/2682": No space left o
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 10/18/06 19:57, Rick Gigger wrote:
> To make a long story short lets just say that I had a bit of a hardware
> failure recently.
>
> If I got an error like this when trying to dump a db from the mangled
> data directory is it safe to say it's total
To make a long story short lets just say that I had a bit of a
hardware failure recently.
If I got an error like this when trying to dump a db from the mangled
data directory is it safe to say it's totally hosed or is there some
chance of recovery?
pg_dump: ERROR: could not open relation
Hi!
You can compile it with MinGW - www.mingw.org.
My test function was just a simple one for writing
text to file:=== FILE =#include
"postgres.h"#include #include "fmgr.h"#include
"utils/builtins.h"#include "storage/fd.h"
PG_FUNCTION_INFO_V1(writelog_tofile)
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 10/18/06 18:08, Tom Lane wrote:
> Ron Johnson <[EMAIL PROTECTED]> writes:
>> We'll be using RHES4, I guess, so if it uses 7.4, then I'll have to
>> convince the SysAdmin to install 8.1 or 8.2.
>
>
> Red Hat is now selling an "Application Stack" ad
Ron Johnson <[EMAIL PROTECTED]> writes:
> We'll be using RHES4, I guess, so if it uses 7.4, then I'll have to
> convince the SysAdmin to install 8.1 or 8.2.
Red Hat is now selling an "Application Stack" addon for RHEL4 that
provides Postgres 8.1.x, as well as more modern versions of some other
pa
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 10/18/06 17:56, Jim C. Nasby wrote:
> On Wed, Oct 18, 2006 at 05:42:22PM -0500, Ron Johnson wrote:
>>> In any case, you'll be much, much happier if you do this project on at
>>> least 8.1.x, as 7.4 is pretty long in the tooth. Due to Red Hat's
>>> s
On Wed, Oct 18, 2006 at 05:42:22PM -0500, Ron Johnson wrote:
> > In any case, you'll be much, much happier if you do this project on at
> > least 8.1.x, as 7.4 is pretty long in the tooth. Due to Red Hat's
> > support requirements it will probably remain supported for a few more
> > years by Tom/th
Hi,
I want to add a
user defined function using “Version-1 Calling Conventions” but
getting a link error.
I am using MS
Visual C++ .NET (V 7.1.3) on Win XP SP 2. PostgreSQL 8.1.3.
Am I missing
some lib or some other file?
I saw earlier
thread “building and linking C user def
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 10/18/06 17:22, Jim C. Nasby wrote:
> On Wed, Oct 18, 2006 at 04:27:21PM -0500, Ron Johnson wrote:
>> -BEGIN PGP SIGNED MESSAGE-
>> Hash: SHA1
>>
>> On 10/18/06 16:08, Jim C. Nasby wrote:
>>> On Mon, Oct 16, 2006 at 06:10:18PM +0300, Adrian
On Wed, Oct 18, 2006 at 04:27:21PM -0500, Ron Johnson wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> On 10/18/06 16:08, Jim C. Nasby wrote:
> > On Mon, Oct 16, 2006 at 06:10:18PM +0300, Adrian Suciu wrote:
> >> Hi everybody!
> >> I ask you for your help on a problem I have.
> >> I ha
Thanks for the response Ragnar. I would have expected this query to
fail, since the sub-query doesn't work by itself:
SELECT foo_field FROM foo WHERE foo_field IN (SELECT foo_field FROM par);
But it obviously doesn't. So does that subselect implicitly read as:
IN (SELECT foo_field FROM par
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 10/18/06 16:08, Jim C. Nasby wrote:
> On Mon, Oct 16, 2006 at 06:10:18PM +0300, Adrian Suciu wrote:
>> Hi everybody!
>> I ask you for your help on a problem I have.
>> I have a postgresql 7.4 running on a dual 4 GB RAM server, but I have
>> some VE
And PLEASE do not post something to 3 lists; it's a lot of extra traffic
for no reason.
Moving to -hackers.
On Wed, Oct 18, 2006 at 05:15:13PM -0400, jungmin shin wrote:
> Hello all,
>
> I read a paper, which is Query optimization in the presence of Foreign
> Functions.
> And the paper , there
On Wed, Oct 18, 2006 at 05:15:13PM -0400, jungmin shin wrote:
> Hello all,
>
> I read a paper, which is Query optimization in the presence of Foreign
> Functions.
> And the paper , there is a paragraph like below.
>
> In order to reduce the number of invocations, caching the results of
> invoca
Hello all,
I read a paper, which is Query optimization in the presence of Foreign Functions.
And the paper , there is a paragraph like below.
In order to reduce the number of invocations, caching the results of invocation was suggested in Postgres.
I'd like to know in detail about how postg
On Mon, Oct 16, 2006 at 06:10:18PM +0300, Adrian Suciu wrote:
> Hi everybody!
> I ask you for your help on a problem I have.
> I have a postgresql 7.4 running on a dual 4 GB RAM server, but I have
> some VERY memory intense queries, that put processor up to 40%. I see
Note that you're likely to
On Tue, Oct 17, 2006 at 02:43:28PM -0400, Vivek Khera wrote:
>
> On Oct 17, 2006, at 2:35 PM, Steve Poe wrote:
>
> >Vivek,
> >
> >What methods of backup do you recommend for medium to large
> >databases? In our example, we have a 20GB database and it takes 2
> >hrs to load from a pg_dump file
Chris Browne <[EMAIL PROTECTED]> writes:
> (gdb) print addr->ai_addr->sa_data
> $18 = "\000\001\177\000\000\001\000\000\000\000\000\000\000"
Hmm, that looks a bit odd --- what's the full declaration of structs
sockaddr and sockaddr_in on that machine?
regards, tom lane
--
[EMAIL PROTECTED] writes:
> Is there any command to drop all the database at once>
shutdown postmaster, rm -rf $PGDATA, initdb, start postmaster ...
regards, tom lane
---(end of broadcast)---
TIP 4: Have you searched our lis
Brad Nicholson <[EMAIL PROTECTED]> writes:
> On Wed, 2006-10-18 at 15:59 -0400, Tom Lane wrote:
>> Also, do regular connections to this postmaster work across TCP/IP?
>> If getaddrinfo() is broken I'd expect there to be problems binding
>> to the postmaster's listen socket too ...
> Yes, TCP/IP co
On Wed, Oct 18, 2006 at 04:31:57PM -0400, Ron Peterson wrote:
> I'm having a hard time finding any examples of functions returning
> timestamps I can study to see how they are handled internally. I'm sure
> it's only a line or two of code.
...I just found date.c
--
Ron Peterson
https://www.yel
> > > Should work fine on Windows. fileno() is deprecated however, with
> > > the following comment:
> > > C:\Program Files\Microsoft Visual Studio
> > > 8\VC\INCLUDE\stdio.h(688) : see
> > > declaration of 'fileno'
> > > Message: 'The POSIX name for this item is deprecated.
> >
[EMAIL PROTECTED] (Tom Lane) writes:
> Brad Nicholson <[EMAIL PROTECTED]> writes:
>> On Wed, 2006-10-18 at 14:31 -0400, Tom Lane wrote:
>>> Would you try strace'ing postmaster start to see what gets passed to the
>>> socket() and bind() calls just before this message comes out?
>
>> Here is the rel
On Tue, Oct 17, 2006 at 09:07:08PM -0400, Ron Peterson wrote:
> On Tue, Oct 17, 2006 at 03:25:05PM -0400, Ron Peterson wrote:
>
> > I've written some PostgreSQL C functions which expose the functionality
> > of Theodore Ts'o's UUID library.
% select y_uuid_time( y_uuid_generate_time() );
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 10/18/06 14:08, [EMAIL PROTECTED] wrote:
> Is there any command to drop all the database at once>
> drop database dbname
> drops the individual database.
> I am using ver8.1
> thanks,
DROP DATABASE ;
- --
Ron Johnson, Jr.
Jefferson LA USA
Is "c
Hugo wrote:
> Hi, how can I know all the foreign key constrainst that references a
> particular pk ?
>
You can try this:
SELECT c_from.relname AS table,
(SELECT attname FROM pg_catalog.pg_attribute a WHERE
a.attrelid=c_from.oid AND attnum = array_to_string(conkey,',')) AS column
FROM pg_catalog.p
On Wed, 2006-10-18 at 15:59 -0400, Tom Lane wrote:
> Brad Nicholson <[EMAIL PROTECTED]> writes:
> > On Wed, 2006-10-18 at 14:31 -0400, Tom Lane wrote:
> >> Would you try strace'ing postmaster start to see what gets passed to the
> >> socket() and bind() calls just before this message comes out?
>
Brad Nicholson <[EMAIL PROTECTED]> writes:
> On Wed, 2006-10-18 at 14:31 -0400, Tom Lane wrote:
>> Would you try strace'ing postmaster start to see what gets passed to the
>> socket() and bind() calls just before this message comes out?
> Here is the relative output from truss.
> socket(2, 2, 0)
Hi, how can I know all the foreign key constrainst that references a particular pk ?this is on postgres 8.1.4 on susethanks for any adviceHugo
On Wed, 2006-10-18 at 14:31 -0400, Tom Lane wrote:
> Brad Nicholson <[EMAIL PROTECTED]> writes:
> > On Wed, 2006-10-18 at 13:00 -0400, Tom Lane wrote:
> >> That's bizarre. What error conditions does your man page for bind(2)
> >> document as yielding EACCES? The only one mentioned on my systems i
Is there any command to drop all the
database at once>
drop database dbname
drops the individual database.
I am using ver8.1
thanks,
Tom Lane wrote:
> "Magnus Hagander" <[EMAIL PROTECTED]> writes:
> > Should work fine on Windows. fileno() is deprecated however, with the
> > following comment:
> > C:\Program Files\Microsoft Visual Studio
> > 8\VC\INCLUDE\stdio.h(688) : see
> > declaration of 'fileno'
> > Message:
Bernard Grosperrin wrote:
> I wants to make a view giving me some statistics.
>
> I am not sure to understand why something like this
>
> SELECT location_id, (sold_parts_amount_dly + sold_labor_amount_dly) /
> (sold_parts_amount_dly + sold_labor_amount_dly) from sales
>
> give me a division by zer
>> Is it Ok to use COPY BINARY FROM STDIN instead of multiple INSERTs?
>I don't think I would use BINARY, it seems likely to be susceptible
>to changes in the underlying data type storage. From the docs:
>"To determine the appropriate binary format for the actual tuple data
>you should consult
Brad Nicholson <[EMAIL PROTECTED]> writes:
> On Wed, 2006-10-18 at 13:00 -0400, Tom Lane wrote:
>> That's bizarre. What error conditions does your man page for bind(2)
>> document as yielding EACCES? The only one mentioned on my systems is
>> "protected address", but we aren't requesting a reserv
I just had this problem last night my local firewall was blocking
connections on the loopback interface.
On Wed, 18 Oct 2006, Brad Nicholson wrote:
Can someone please provide a bit of information where the following
error is coming from? This is PG 8.1.3 on AIX 5.3
LOG: could not bind s
On Wed, 2006-10-18 at 13:00 -0400, Tom Lane wrote:
> Brad Nicholson <[EMAIL PROTECTED]> writes:
> > Can someone please provide a bit of information where the following
> > error is coming from? This is PG 8.1.3 on AIX 5.3
>
> > LOG: could not bind socket for statistics collector: Permission deni
On Wed, 2006-10-18 at 00:41 -0700, roopa perumalraja wrote:
> Hi
>
> Thanks for your reply.
>
> explain select * from tk_20060403;
> QUERY
> PLAN
> --
> Seq S
Stefan Sassenberg <[EMAIL PROTECTED]> writes:
> Is it a necessary restriction that the db encoding must match the
> lc_ctype?
If you set the LC_ variables to "C" you can get away with using
different encodings, but I wouldn't recommend it for any other locale
setting. Aside from the message tran
"Magnus Hagander" <[EMAIL PROTECTED]> writes:
> Should work fine on Windows. fileno() is deprecated however, with the
> following comment:
> C:\Program Files\Microsoft Visual Studio
> 8\VC\INCLUDE\stdio.h(688) : see
> declaration of 'fileno'
> Message: 'The POSIX name for this item
On Oct 18, 2006, at 5:20 AM, Ilja Golshtein wrote:
When starting a database from scratch it is much faster to import the
data and then create the indexes. The time to create index on a full
table is less than the extra time from each index update from the
inserts. The more indexes to update the
Brad Nicholson <[EMAIL PROTECTED]> writes:
> Can someone please provide a bit of information where the following
> error is coming from? This is PG 8.1.3 on AIX 5.3
> LOG: could not bind socket for statistics collector: Permission denied
That's bizarre. What error conditions does your man page
On 10/18/06, Ron Johnson <[EMAIL PROTECTED]> wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 10/18/06 09:47, Merlin Moncure wrote:
> On 10/18/06, Ron Johnson <[EMAIL PROTECTED]> wrote:
>> > I tested binary quite a bit and only found it to be a win if moving
>> > blobs in and out of the d
Is there any inbuilt facility in postgres for connection pooling .. ??
Not built in, but...
http://pgpool.projects.postgresql.org/
Never used it myself...
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
Ron Johnson wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> On 10/18/06 09:47, Merlin Moncure wrote:
> > On 10/18/06, Ron Johnson <[EMAIL PROTECTED]> wrote:
> >> > I tested binary quite a bit and only found it to be a win if moving
> >> > blobs in and out of the database. On 'normal'
> >> Hmm. If the messages are less than PIPE_BUF bytes long
> (4096 bytes
> >> on
> >> Linux) then the writes are supposed to be atomic.
>
> > Some of them involve long messages (>4K), but there are
> many that do
> > not (like the ones I had posted at the start of this thread).
>
> I checke
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 10/18/06 09:47, Merlin Moncure wrote:
> On 10/18/06, Ron Johnson <[EMAIL PROTECTED]> wrote:
>> > I tested binary quite a bit and only found it to be a win if moving
>> > blobs in and out of the database. On 'normal' tables of mixed fields
>> > type
Can someone please provide a bit of information where the following
error is coming from? This is PG 8.1.3 on AIX 5.3
LOG: could not bind socket for statistics collector: Permission denied
LOG: disabling statistics collector for lack of working socket
What exactly does the PG user not have app
On 10/18/06, Ron Johnson <[EMAIL PROTECTED]> wrote:
> I tested binary quite a bit and only found it to be a win if moving
> blobs in and out of the database. On 'normal' tables of mixed fields
> types of small size, it can actually be slower. Binary is a bit
> faster for native types and bytea,
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 10/18/06 08:03, Merlin Moncure wrote:
> On 10/18/06, Martijn van Oosterhout wrote:
>> Binary may be slightly faster because the datum parsing can be
>> partially skipped, but that's hardly much benefit over a text copy.
>
> I tested binary quite a
On 10/18/06, Najib Abi Fadel <[EMAIL PROTECTED]> wrote:
Hi,
i need to move my postgres users with their passwords from one postgres
version (7.3) to a newer one (8.1) .
Is there an automatic way to do that without having to recreate the users
with their passwords ??
did you try pg_dumpall?
On 10/18/06, Jan Harders <[EMAIL PROTECTED]> wrote:
and, as guessed, takes forever. tried to ANALYZE the table but no change.
Anyone got any ideas? I just don't understand why it's sorting the values
while the index should already be sorted...
Oh, btw, I'm on 7.4 (sarge stable version). Could t
Hi everyone,
I'm new to postgre so please don't take anything implied but rather throw
questions when something's unclear.
Here's my problem or rather my question: I have a table with a category
(four different values here), some data-fields I need and a few
timestampfields indicating when which d
Ilja Golshtein wrote:
And my question remains.
Is it Ok to use COPY BINARY FROM STDIN instead of multiple INSERTs?
If it does what you want then it is OK to use it.
--
Shane Ambler
[EMAIL PROTECTED]
Get Sheeky @ http://Sheeky.Biz
---(end of broadcast)---
On 10/18/06, Ilja Golshtein <[EMAIL PROTECTED]> wrote:
I've tried to play with batches and with peculiar constructions
like INSERT (SELECT .. UNION ALL SELECT ..) to improve performance, but not
satisfied with the result I've got.
postgresql 8.2 (beta) supports the 'multiple insert' syntax, so
On 10/18/06, Martijn van Oosterhout wrote:
Binary may be slightly faster because the datum parsing can be
partially skipped, but that's hardly much benefit over a text copy.
I tested binary quite a bit and only found it to be a win if moving
blobs in and out of the database. On 'normal' table
>The reason why copy is faster is because it doesn't have to
>parse/plan/execute all the queries. In exchange you can't use
>expressions or joins to fill the table, only raw data.
In other words, COPY has no hidden catches, and I should go with it and don't
worry.
Correct interpretation? ;)
>Bi
On Wed, Oct 18, 2006 at 04:20:41PM +0400, Ilja Golshtein wrote:
> And my question remains.
> Is it Ok to use COPY BINARY FROM STDIN instead of multiple INSERTs?
The reason why copy is faster is because it doesn't have to
parse/plan/execute all the queries. In exchange you can't use
expressions or
>When starting a database from scratch it is much faster to import the
>data and then create the indexes. The time to create index on a full
>table is less than the extra time from each index update from the
>inserts. The more indexes to update the more time updating indexes takes.
>
>The proble
Sandeep Kumar Jakkaraju wrote:
Is Postgres good for large Applications ??
Yes.
cf., e.g., "http://www.computerworld.com.au/index.php?id=760310963";
"...
Vice president of operations at Afilias, Ram Mohan said the .ORG
database will be based on a standard implementation of PostgreSQL
versi
In response to "J S B" <[EMAIL PROTECTED]>:
> Hi,
> I have the following scenario:-
>
> 1. There's a function in the postgres datbase that when executed calls a
> shared object (dynamically loaded).
> 2. The shared object is a Client (made using socket library) which connects
> to a server (coded
Ilja Golshtein wrote:
Sounds like your working with an existing database - if you are starting
from scratch (inserting data into an empty database) then there are
other things that can help too.
I am working with existing database, though I am interested what "other things"
you mean.
Basica
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 10/17/06 22:14, Michael Glaesemann wrote:
>
> On Oct 18, 2006, at 9:46 AM, Ron Johnson wrote:
>
>> SMALLINT(2)
>> INTEGER(2)
>> BIGINT(2)
>
>> Are these data-types not in PG, or am I missing something?
>
>
> http://www.postgresql.org/docs
Roopa,
I think that by defintion a "SELECT * FROM ;" will always take
longer as the table increases in size (but if anyone who is more versed in
theory of searches, sorts, etc. contradicts me I'll happily listen!). Note that
the database could increase enormously with no direct effect on speed;
Hi all, I want a list of currently locked tables. How can I do that? I already found a list from pg_locks table. But how I know the name of the table against relation id of a relation? Nirmalya Lahiri(+91-94331-13536)
Get your own web address for just $1.99/1st yr. We'll help. Yahoo! Small Bu
Hello!
>Using COPY FROM STDIN is much faster than INSERT's (I am sure some out
>there have test times to compare, I don't have any on hand)
Yes, I know it is much faster.
The question is about possible pay for this quickness.
What if COPY, say, locks index until end of transaction (it is just
Tom Lane wrote:
Stefan Sassenberg <[EMAIL PROTECTED]> writes:
[EMAIL PROTECTED] is ISO-8859-15, if that helps. I changed the locale to
en_US.UTF-8 and LC_CTYPE in the environment is set to that value too.
Nevertheless "show lc_ctype" says [EMAIL PROTECTED], even after a postgresql
restart. How
Title: Nachricht
What
disk subsystem do you have? Single disks? Raid? Raid with battery buffered write
cache?
Last
one can improve your performance massively.
--
Matthias
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On Behalf Of roopa perumalrajaS
Ilja Golshtein wrote:
Hello!
One important use case in my libpq based application (PostgreSQL 8.1.4) is a
sort of massive data loading.
Currently it is implemented as a series of plain normal INSERTs
(binary form of PQexecParams is used) and the problem here it is pretty slow.
I've tried to p
explain analyze verbose select * from tk_ ;
roopa perumalraja wrote:
Hi
Thanks for your reply.
explain select * from tk_20060403;
QUERY PLAN
--
Seq S
am Wed, dem 18.10.2006, um 9:47:56 +0200 mailte dfx folgendes:
> The files pg_hba.conf and postgreql.conf are correctly configured (in my
> opinion...)
Sure? You need an entry for your LAN in the pg_hba - file.
>
> Is there some special setting to 'see' the SQL server from the network for
>
Hi,i need to move my postgres users with their passwords from one postgres version (7.3) to a newer one (8.1) . Is there an automatic way to do that without having to recreate the users with their passwords ??Thanks for any helpNajib.
Richard Broersma Jr wrote:
>> id id_1id_2 date_time
>> 1101 10002006-07-04 11:25:43
>> I want to find all records have same id_1, but different id_2 and
have
>> difference in time less than 5 minutes.
>> In this case this is record 1 and record 3.
>> How can I do this ?
>
> I a
Hi,I have the following scenario:-1. There's a function in the postgres datbase that when executed calls a shared object (dynamically loaded).2. The shared object is a Client (made using socket library) which connects to a server (coded again using socket library) hosted on some other machine.
3. T
Tom Lane wrote:
> I checked around with some kernel/glibc gurus in Red Hat, and the
> consensus seemed to be that we'd be better off to bypass fprintf() and
> just send message strings to stderr using write() --- ie, instead of
> elog.c doing
>
> fprintf(stderr, "%s", buf.data);
>
> d
Dear
Sirs,
I have some trouble
to connect to PostgreSQL .8.0 running on Fedora Core 5 server with PgAdmin III
v. 1.4.2 running on Windows 2000 Server on the same (local)
network.
The database server
is accessible from PgAdmin ||| running on the same server (Linux) and
it seems OK but i
Hi Thanks for your reply. explain select * from tk_20060403; QUERY PLAN -- Seq Scan on tk_20060403 (cost=0.00..95561.30 rows=3609530 width=407)(1 row) will
92 matches
Mail list logo
