On 14/04/11 23:25, Vick Khera wrote:
On Thu, Apr 14, 2011 at 12:19 AM, Benjamin Smith
mailto:li...@benjamindsmith.com>> wrote:
I was wondering if anybody here could comment on the benefits of SSD
in similar, high-demand rich schema situations?
For the last several months, I've been usi
Dear Everybody!
I want to ask that have some way to install PGSQL 9.0 as two instances
in one machine?
Most important question. The OS is can be Windows or Linux.
I asked this, because formerly we heard about a story. I cite this as I
remember:
We have some product, and in the only one
On 20/04/11 04:28, Yeb Havinga wrote:
On 2011-04-19 19:07, Benjamin Smith wrote:
On Sunday, April 17, 2011 01:55:02 AM Henry C. wrote:
>
> Exactly. Be aware of the risks, plan for failure and reap the rewards.
Just curious what your thoughts are with respect to buying SSDs and
mirroring the
In this discussion there was a lot of talk of transport compression in
Postgres, (also specifically wondering about JDBC as well) did anything
ever come of that discussion?
http://postgresql.1045698.n5.nabble.com/Compression-on-SSL-links-td2261205.html
Hi,
Apologies for flooding the list. I was updating the table when I should
update the view.
That's the price for working after a regular day job.
Regards,
Geraldo Lopes de Souza
2011/4/16 Geraldo Lopes de Souza
> Hi,
>
> I'm trying to implement tenant view filter with postgres. The docs sa
On Tue, Apr 19, 2011 at 5:06 PM, SUBHAM ROY wrote:
> Suppose Postgres is installed in two computers C1 & C2.
> C1 have some database tables. How can I copy these database tables from C1
> to C2.
> I mean to say that can I copy tables from postgres installed in one m/c to
> another m/c.
> Is there
Suppose Postgres is installed in two computers C1 & C2.
C1 have some database tables. How can I copy these database tables from C1
to C2.
I mean to say that can I copy tables from postgres installed in one m/c to
another m/c.
Is there any command in postgres to do so or any other short cut techniqu
On 18 April 2011 22:06, Tore Halvorsen wrote:
> Well, refering to the computed value may be nonsensical, but
> couldn't it be some sort of query rewrite? So that...
>
> SELECT x/y AS z FROM tab WHERE y <> 0 AND z > 2
>
> ... is a shorthand for
>
> SELECT x/y AS z FROM tab WHERE y <> 0 AND x
On 04/19/2011 08:56 AM, Phoenix Kiula wrote:
While I fix some bigger DB woes, I have learned a lesson. Huge indexes
and tables are a pain.
Which makes me doubly keen on looking at partitioning.
Before jumping into partitioning it would be useful to know specifically
what pain you are having wit
On Tue, Apr 19, 2011 at 8:09 PM, tamanna madaan
wrote:
> Sometimes this query gets stuck for unknown reason . So, for this particular
> query I want to set a timeout
> . I dont want to change "statement_timeout" in postgresql.conf as this would
> affect all the connections/queries.
> I just want
Hi All
I am using postgres-8.1.2 . In postgresql.conf I have set :
#statement_timeout = 0
I am executing the below query just to check if postgres is allowing
connections or not .
psql -Uslon -d -h -c "select 1;"
Sometimes this query gets stuck for unknown reason . So, for this particu
On 04/19/11 11:48 AM, Greg Corradini wrote:
Hello,
I'm getting 'service user account 'postgres' could not be created'
when using the postgresql-8.4.2-1 one-click installer (i also get the
same error with a new version of postgresql 8.4.8-1)
So i know in the past (version 8.3.x) there were pro
With R2, I had to install using the admin account. I got those errors
before. It worked once I used a admin account. If that doesn't work you
might want to try turning UAC off, do the install and then turn back on.
Best Regards
Michael Gould
"Greg Corradini" wrote:
>Hello,
>I'
Hello,
I'm getting 'service user account 'postgres' could not be created' when
using the postgresql-8.4.2-1 one-click installer (i also get the same error
with a new version of postgresql 8.4.8-1)
So i know in the past (version 8.3.x) there were problems with Windows
Server 2008 R2 running Active
On 2011-04-19 19:07, Benjamin Smith wrote:
On Sunday, April 17, 2011 01:55:02 AM Henry C. wrote:
>
> Exactly. Be aware of the risks, plan for failure and reap the rewards.
Just curious what your thoughts are with respect to buying SSDs and
mirroring them with software RAID 1. (I use Linux/C
I'm getting some really weird behavior in a function I swear was working
a couple of weeks ago.
For reasons I do not agree with, the database our main application
relies on stores times without time zones. Instead, we store each time
twice, once as a timestamp containing wallclock time and the
On Sunday, April 17, 2011 01:55:02 AM Henry C. wrote:
> On Thu, April 14, 2011 18:56, Benjamin Smith wrote:
> > After a glowing review at AnandTech (including DB benchmarks!) I decided
> > to spring for an OCX Vertex 3 Pro 120 for evaluation purposes. It cost
> > about $300
> >
> > with shipping,
While I fix some bigger DB woes, I have learned a lesson. Huge indexes
and tables are a pain.
Which makes me doubly keen on looking at partitioning.
Most examples I see online are partitioned by date. As in months, or
quarter, and so on. This doesn't work for me as I don't have too much
logic req
On Tue, Apr 19, 2011 at 4:39 PM, giova wrote:
> My problem is that i want to do an INSERT into a log table before to raise
> the exception. But RAISE EXCEPTION cancels my Insert.
That's the point of transaction, if it failed the data and any other
changes are rolled back.
You can use dblink (http
On Tuesday, April 19, 2011 6:39:23 am giova wrote:
> Hi.
>
> I made a function that Raise exception with some conditions.
> No problem with that, it is the goal.
>
> My problem is that i want to do an INSERT into a log table before to raise
> the exception. But RAISE EXCEPTION cancels my Insert.
Hi.
I made a function that Raise exception with some conditions.
No problem with that, it is the goal.
My problem is that i want to do an INSERT into a log table before to raise
the exception. But RAISE EXCEPTION cancels my Insert.
How to force the insert to not being cancelled please?
Note that
On Tue, Apr 19, 2011 at 8:48 AM, Jens Wilke wrote:
> On Tue, Apr 19, 2011 at 04:02:01AM +0530, Vibhor Kumar wrote:
>
>> > IIRC "vacuum full" mode rewrites the indexes as well.
>>
>> Till 8.4 no. From 9.0 onwards yes. However VACUUM FULL still locks the table.
>
> Don't be confused with the "vacuum
On Tue, Apr 19, 2011 at 04:02:01AM +0530, Vibhor Kumar wrote:
> > IIRC "vacuum full" mode rewrites the indexes as well.
>
> Till 8.4 no. From 9.0 onwards yes. However VACUUM FULL still locks the table.
Don't be confused with the "vacuum full" term.
This has nothing to do with the postgresql "vac
2011/4/19 Júlio Almeida
> If I run
> create table newtable (like oldtable including constraints);
> in the SQL window with works just file.
> But if i execute
> execute 'create table '||newtable||' (LIKE '||oldtable||' including
> constraints)';
> inside a function, in a LOOP, the constraints are
> -Original Message-
> From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
> ow...@postgresql.org] On Behalf Of Stefan Keller
> Sent: Sunday, April 17, 2011 2:04 PM
> To: pgsql-general List
> Subject: [GENERAL] How to configure a read-only database server and
> session? (Was:
Hallo,
i have a possible feature request.
It is not possible to get the sql statement itself and the output of the
statement in a user-friendly way to an output file (option \o psql),
this is only possible outside of psql, when calling this function with
an option -L (psql -L log.txt).
The nice t
Hi Tom,
Op maandag 18 april 2011, schreef Tom Lane:
> Hmmm look into pg_shdepend to see if there are entries linking
> those functions to an owner.
mmm, indeed it seems that some things are our of sync here
the following is coming from the production database, thus after the 'reassign
from
Hello,
If I run
create table newtable (like oldtable including constraints);
in the SQL window with works just file.
But if i execute
execute 'create table '||newtable||' (LIKE '||oldtable||' including
constraints)';
inside a function, in a LOOP, the constraints aren't created.
What is the pr
28 matches
Mail list logo
