Joshua D. Drake wrote:
> On Mon, 2009-03-16 at 23:02 -0400, Tom Lane wrote:
>> "Raji Sridar (raji)" writes:
>>> I don't mind going to 8.3 or later. I want to ensure that Postgres is
>>> tested on Windows 2008 and patches created like other platforms. How do
>>> I enable that?
>> Contribute a test
Hi guys! This'll hopefully be an easy question for one of the perf guys
like Tom..
I'm wondering what the performance advantage is to using a clustered
index. Take the following example: I have a table of recipes with a
recipeid, and a table of comments that various users might have entered
On Tue, 2009-03-17 at 10:45 +0530, Nagalingam, Karthikeyan wrote:
> Thanks Stefan for all your answers. My last question is "What is the
> Mostly used Disaster Recovery Solution for Postgresql in storage
> environment."
That vastly depends. The most common is likely warm standby (PITR). If
you are
On Mon, Mar 16, 2009 at 11:15 PM, Nagalingam, Karthikeyan
wrote:
> Thanks Stefan for all your answers. My last question is "What is the
> Mostly used Disaster Recovery Solution for Postgresql in storage
> environment."
We use two methods of backup to keep the database afloat amid things
going hor
Thanks Stefan for all your answers. My last question is "What is the
Mostly used Disaster Recovery Solution for Postgresql in storage
environment."
Regards
Karthikeyan.N
-Original Message-
From: Stefan Kaltenbrunner [mailto:ste...@kaltenbrunner.cc]
Sent: Tuesday, March 17, 2009 1:53 A
On Monday 16 March 2009 17:55:00 Kostadin Solakov wrote:
> John R Pierce wrote:
>
> thats odd, as a domain socket should be slightly -faster- than a tcp/ip
> socket. now, since you say 'previous host' I could wonder if other
> configuration items are impacting this, such as buffer sizes in
> post
On Mon, 2009-03-16 at 23:02 -0400, Tom Lane wrote:
> "Raji Sridar (raji)" writes:
> > I don't mind going to 8.3 or later. I want to ensure that Postgres is
> > tested on Windows 2008 and patches created like other platforms. How do
> > I enable that?
>
> Contribute a test machine to the buildfarm
I declared a field as DECIMAL(19,6)
when doing select thatfield from tb1
for some reason ODBC thinks that it is a double
I think it has to be a string, otherwise precision is lost
or am I not understanding this right?
I tried to do
select thefield\\:\\:varchar
but for some reason that did n
Daniel Manesajian writes:
> When I try a simple query "select avg(my_int) over (order by my_int rows
> unbounded preceding) order by 1;" I get an error:
> ERROR: syntax error at or near "over"
You sure you're actually talking to the 8.4 server? Because that's
exactly what you'd get if you trie
Hi,
I'm trying to get an advance taste of the window function feature that I
believe is supposed to be in 8.4. I'm running 8.4devel snapshot (dated Jan-01
which seems kind of old) grabbed from the snapshot page on the postgresql
website.
When I try a simple query "select avg(my_int) ove
> -Original Message-
> From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
> ow...@postgresql.org] On Behalf Of Tom Lane
> Sent: Monday, March 16, 2009 8:02 PM
> To: Raji Sridar (raji)
> Cc: j...@commandprompt.com; Scott Marlowe; r...@iol.ie; pgsql-
> gene...@postgresql.org
> Su
Joachim Tranvåg wrote:
> Hi, I am trying to install PostgreSQL on Windows Vista 32bit, I have
> deactivated UAC and the only kind of Firewall I have is Avast Home.
Just so you know, there's rarely any need to deactivate UAC. Just
shift-right-click on installers and choose "Run as administrator".
"Raji Sridar (raji)" writes:
> I don't mind going to 8.3 or later. I want to ensure that Postgres is
> tested on Windows 2008 and patches created like other platforms. How do
> I enable that?
Contribute a test machine to the buildfarm:
http://www.pgbuildfarm.org/index.html
(Although I have to co
Raji Sridar (raji) wrote:
I don't mind going to 8.3 or later. I want to ensure that Postgres is
tested on Windows 2008 and patches created like other platforms. How do
I enable that?
postgres isn't 'patched', there are incremental releases, like 8.3.5,
8.3.6. within a given X,Y, you can i
I don't mind going to 8.3 or later. I want to ensure that Postgres is
tested on Windows 2008 and patches created like other platforms. How do
I enable that?
Thanks
Raji
-Original Message-
From: Joshua D. Drake [mailto:j...@commandprompt.com]
Sent: Monday, March 16, 2009 7:10 PM
To: Raji Sr
On Mon, 2009-03-16 at 18:12 -0700, Raji Sridar (raji) wrote:
> Thanks for the prompt responses. None of the urls mention Windows 2008.
> Looks like it is not supported. Who should I approach to get this
> supported and how?
How do you mean "supported"? I doubt that the community is going to back
p
Thanks for the prompt responses. None of the urls mention Windows 2008.
Looks like it is not supported. Who should I approach to get this
supported and how?
Thanks
Raji
-Original Message-
From: Scott Marlowe [mailto:scott.marl...@gmail.com]
Sent: Monday, March 16, 2009 4:16 PM
To: j...@com
Hello,
a newbie question:
I am using ODBC on windows (the unicode version) to connect to 8.3.3
running on
the same machine (XP 32 bit).
My C++ program uses OTL C++ library (it's ODBC functions)
Every time I execute a simple
select fld from mytable;
I see this
LOG: duration: 0.000 ms statem
Did you restart the server after making your changes to pg_hba.conf?
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Joachim Tranvåg
Sent: Monday, March 16, 2009 2:03 PM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] (0x274D/10061)
On Mon, Mar 16, 2009 at 4:58 PM, Joshua D. Drake wrote:
> On Mon, 2009-03-16 at 22:55 +, Raymond O'Donnell wrote:
>> On 16/03/2009 22:42, Raji Sridar (raji) wrote:
>> > I would like to know if Postgres 8.2.x is supported on Windows 2008 (32
>> > bit). If not, what is version of Postgres suppor
On Mon, Mar 16, 2009 at 4:42 PM, Raji Sridar (raji) wrote:
> Hi,
>
> I would like to know if Postgres 8.2.x is supported on Windows 2008 (32
> bit). If not, what is version of Postgres supported on Windows 2008? PLs
> let me know.
Due to some problems with older versions of pgsql and windows, it
On Mon, 2009-03-16 at 22:55 +, Raymond O'Donnell wrote:
> On 16/03/2009 22:42, Raji Sridar (raji) wrote:
> > I would like to know if Postgres 8.2.x is supported on Windows 2008 (32
> > bit). If not, what is version of Postgres supported on Windows 2008? PLs
> > let me know.
>
> There's a list
On 16/03/2009 22:42, Raji Sridar (raji) wrote:
> I would like to know if Postgres 8.2.x is supported on Windows 2008 (32
> bit). If not, what is version of Postgres supported on Windows 2008? PLs
> let me know.
There's a list of supported platforms in the manual - have a rummage there.
Ray.
Hi,
I would like to know if Postgres 8.2.x is supported on Windows 2008 (32
bit). If not, what is version of Postgres supported on Windows 2008? PLs
let me know.
Thanks
Raji
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.p
John R Pierce wrote:
thats odd, as a domain socket should be slightly -faster- than a tcp/ip
socket. now, since you say 'previous host' I could wonder if other
configuration items are impacting this, such as buffer sizes in
postgresql.conf, relative speed of disk controllers, etc. or perhap
I am using pgadmin to attach to PostgreSQL.
My pg_hba.conf file is default with md5 instead of trust, but have tried to
change to trust, without that having any affect on my connecting issue.
And yes, I see 6 postgres.exe services running.
Since it won't properly install it might be some of the
Scott Marlowe wrote:
On Mon, Mar 16, 2009 at 2:03 PM, Stefan Kaltenbrunner
wrote:
So in my understanding LVM is safe on disks that have write cache disabled
or "behave" as one (like a controller with a battery backed cache).
For storage with write caches it seems to be unsafe, even if the files
Kostadin Solakov wrote:
Anyway I managed to connect to localhost, but after I made changes to
pg_connect and I removed the host name
FROM
1. pg_pconnect("host=localhost dbname=mydb user=myuser
password=mypassword");
TO
1. pg_pconnect("dbname=mydb user=myuser password=mypassword");
Now
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Joachim Tranvåg
Sent: Monday, March 16, 2009 1:20 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] (0x274D/10061) on Install
>Hi, I am trying to install PostgreSQL on Windows Vista 32bit, I
Stefan Kaltenbrunner wrote:
So in my understanding LVM is safe on disks that have write cache
disabled or "behave" as one (like a controller with a battery backed
cache).
what about drive write caches on battery backed raid controllers? do
the controllers ensure the drive cache gets flushed
On Mon, Mar 16, 2009 at 2:03 PM, Stefan Kaltenbrunner
wrote:
> So in my understanding LVM is safe on disks that have write cache disabled
> or "behave" as one (like a controller with a battery backed cache).
> For storage with write caches it seems to be unsafe, even if the filesystem
> supports b
Hi, I am trying to install PostgreSQL on Windows Vista 32bit, I have
deactivated UAC and the only kind of Firewall I have is Avast Home.
I am installing postgresql-8.3.6-2.zip, have also tried the 8.3.5.1.
I am installing with everything as standard.
During installation, during Activating Procedu
Nagalingam, Karthikeyan wrote:
Hi,
we are in the process of finding the best solution for Postgresql
deployment with storage controller. I have some query, Please give some
suggestion for the below
1) Can we get customer deployment scenarios for postgresql with storage
controller. Any fl
Tom Lane wrote:
Jack Orenstein writes:
The transaction rates I'm getting seem way too high: 2800-2900 with
one thread, 5000-7000 with ten threads. I'm guessing that writes
aren't really reaching the disk. Can someone suggest how to figure out
where, below postgres, someone is lying about writes
Thanks John, I tried that and it works but with some changes I made.
After the changes you suggested I was still getting the same message:
Warning: pg_pconnect() [function.pg-pconnect]: Unable to connect to
PostgreSQL server: could not connect to server: Permission denied Is the
server running on h
On Mon, Mar 16, 2009 at 1:00 AM, Nagalingam, Karthikeyan
wrote:
> Hi,
> we are in the process of finding the best solution for Postgresql
> deployment with storage controller. I have some query, Please give some
> suggestion for the below
>
> 1) Can we get customer deployment scenarios for pos
Scott Marlowe wrote:
On Mon, Mar 9, 2009 at 8:21 PM, Mike Charnoky wrote:
The random sampling query is normally pretty snappy. It usually takes on
the order of 1 second to sample a few thousand rows of data out of a few
million. The sampling is consistently quick, too. However, on some days,
thanks Tom Lane, my problem resolved, I'm trying to re-create my table and
function, and this working well
Tom Lane wrote:
ataherster writes:
... but this function is not work with this error :
ERROR: structure of query does not match function result type
CONTEXT: PL/pgSQL function "pe
Thanks for your reply john.
Regards
Karthikeyan.N
-Original Message-
From: John R Pierce [mailto:pie...@hogranch.com]
Sent: Monday, March 16, 2009 11:08 PM
To: Nagalingam, Karthikeyan
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] deployment query
Nagalingam, Karthikeyan
On Mar 16, 12:08 pm, t...@wildenhain.de (Tino Wildenhain) wrote:
> > Since I have a lot of tables and mirrored backups, I am wondering if
> > there is a way to alter automatically all tables where colname matches
> > 'username'
> > Is there a way to do this?
Enter psql with '-E' flag, and see the
Nagalingam, Karthikeyan wrote:
Hi,
we are in the process of finding the best solution for Postgresql
deployment with storage controller. I have some query, Please give
some suggestion for the below
Doesn't Network Appliance have anyone who could help you with this?
This is the th
doing via shell is one way (long way if you use Windows),
is it possible by updateding postgresql master tables?
- Original Message -
From: "Tino Wildenhain"
To: "Kodok Marton"
Cc:
Sent: Monday, March 16, 2009 6:08 PM
Subject: Re: [GENERAL] alter multiple tables
Hi,
Kodok Marton
Hi,
Kodok Marton wrote:
Hello,
I have in every table columns like:
username character varying(20) NOT NULL
I want to extend the length of varchar in all tables.
next time you should probably consider using a domain type
(or stick to text)
Since I have a lot of tables and mirrored backups
Hello,
I have in every table columns like:
username character varying(20) NOT NULL
I want to extend the length of varchar in all tables.
Since I have a lot of tables and mirrored backups, I am wondering if there is a
way to alter automatically all tables where colname matches 'username'
Is th
Hi,
When setting archive_command in postgresql.conf to something different
than '', in other words, not empty, does it mean that archiving will
be attempted periodically since postgresql starts or just when doing
pg_start_backup and pg_stop_backup?
I just use archived files for recovery process w
On Sun, Mar 15, 2009 at 02:25:11PM -0700, John R Pierce wrote:
> Kynn Jones wrote:
> >That's a fair question. The program in question already gets from the
> >relational database most of the external data it needs. The only
> >exception to this is these large amorphous blobs, as you describe
>
Hi Lius,
Luis Cevallos wrote:
Saludos Cordiales.
Mi nombre es Luis Cevallos y tengo muchas dudas de como hacer para
guardar una imagen desde php hasta una tabla que tiene campo oid no lo
logro hacer claro estoy usando ADODB pero no se como hacerlo.
it would be easier for us to help you if yo
On Mon, Mar 16, 2009 at 8:24 AM, Janning Vygen wrote:
> On Monday 16 March 2009 15:13:51 Scott Marlowe wrote:
>> On Mon, Mar 16, 2009 at 7:15 AM, Janning Vygen wrote:
>> > Hi,
>> >
>> > Why does default_statistic_target defaults to 10?
>> >
>> > I suggest to setting it to 100 by default:
>>
>> Al
On Monday 16 March 2009 15:13:51 Scott Marlowe wrote:
> On Mon, Mar 16, 2009 at 7:15 AM, Janning Vygen wrote:
> > Hi,
> >
> > Why does default_statistic_target defaults to 10?
> >
> > I suggest to setting it to 100 by default:
>
> Already done in 8.4
GREAT! sorry for not searching the archives or
On Mon, Mar 16, 2009 at 12:35 AM, Greenhorn wrote:
> Hi,
>
> I have almost 1300 files from Oracle (no access to oracle server). I
> have to create the tables and data as follows.
(...) snip (...)
> Any recommendation is greatly appreciated :)
Try here:
http://wiki.postgresql.org/wiki/Converting
On Mon, Mar 16, 2009 at 7:15 AM, Janning Vygen wrote:
> Hi,
>
> Why does default_statistic_target defaults to 10?
> I suggest to setting it to 100 by default:
Already done in 8.4
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://
Hi,
we are running a large 8.3 database and had some trouble with a default
statistic target. We had set it to one special table some time ago, when we
got a problem with a growing table starting with sequence scans.
Last week we did manually cluster this table (create table as ... order by;
d
Saludos Cordiales.
Mi nombre es Luis Cevallos y tengo muchas dudas de como hacer para
guardar una imagen desde php hasta una tabla que tiene campo oid no lo
logro hacer claro estoy usando ADODB pero no se como hacerlo.
Por favor.
Gracias.
Que tenga un lindo dia.
--
Sent via pgsql-general mail
Hi,
we ran a large database on moderate hardware. Disks are usually the slowest
part so we do not log every statement. Sometimes we do and our IOwait and CPU
increases by 10%. too much for peak times!
it would be nice if you could say:
log_statement = sample
sample_rate = 100
you would ge
Hi,
we are in the process of finding the best solution for Postgresql
deployment with storage controller. I have some query, Please give some
suggestion for the below
1) Can we get customer deployment scenarios for postgresql with storage
controller. Any flow diagram, operation diagram and im
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Martin Pitt a écrit :
> Cédric Villemain [2009-03-15 23:58 +0100]:
>> Any plan for 8.4 pre-beta package ? (Devrim Gunduz provide usefull rpm
>> package,
>> I'd like to have the same in debian).
>>
>> Can it be in the experimental repository ?
>
> So
Cédric Villemain [2009-03-15 23:58 +0100]:
> Any plan for 8.4 pre-beta package ? (Devrim Gunduz provide usefull rpm
> package,
> I'd like to have the same in debian).
>
> Can it be in the experimental repository ?
So far I usually started packaging those with the first public beta
version, but i
57 matches
Mail list logo
