Hi everybody,
I googled a bit around and also checked the mailing lists but I still
can't make an idea. We plan to use postgres 9 and the Cluster Database
Replica.
My colleagues are asking how many Cluster Databases (initdb) can I
create and run on a single server. I mean, supposed my server
Hi,
In PostgreSQL, is there any performance difference between queries written
using explicit join notation vs implicit join notation in complex
queries?
EXAMPLE: Simple explicit join notation
SELECT *
FROM employee INNER JOIN department
ON employee.DepartmentID = department.DepartmentID;
Hello
no, there is no difference - you can check it via EXPLAIN statement
Regards
Pavel Stehule
2011/10/19 Gnanakumar gna...@zoniac.com:
Hi,
In PostgreSQL, is there any performance difference between queries written
using explicit join notation vs implicit join notation in complex
On 10/19/11 2:46 AM, d.davo...@mastertraining.it wrote:
Hi everybody,
I googled a bit around and also checked the mailing lists but I still can't
make an idea. We plan to use postgres 9 and the Cluster Database Replica.
My colleagues are asking how many Cluster Databases (initdb) can I create
On Tue, Oct 11, 2011 at 8:05 PM, Dave Crooke dcro...@gmail.com wrote:
Hi James
I'm guessing the problem is that the combination of using a view and the way
the view is defined with an in-line temporary table is too complex for the
planner to introspect into, transform and figure out the
Hi Craig,
thanks for your reply. I think I need to add some details on my
question, like why we would need more than one Cluster Database. We are
thinking to use the Streaming Replica feature to keep in sync a number
of little DB servers around the net. The replica should happen on one or
d.davo...@mastertraining.it d.davo...@mastertraining.it wrote:
We are thinking to use the Streaming Replica feature to keep in
sync a number of little DB servers around the net. The replica
should happen on one or more centralized servers. I didn't tested
the replica personally bus as I can
On Wed, Oct 19, 2011 at 9:02 AM, d.davo...@mastertraining.it
d.davo...@mastertraining.it wrote:
Hi Craig,
thanks for your reply. I think I need to add some details on my question,
like why we would need more than one Cluster Database. We are thinking to
use the Streaming Replica feature to
For example:
Table A
-id (PK)
-name
Table B
-table_a_id (PK, FK)
-address
When I do an insert on table B, the database check if value for column
table_a_id exists in table A
But, if I do an update of column address of table B, does the database
check again?
My question is due to
On 19 Oct 2011, at 17:51, Anibal David Acosta wrote:
For example:
Table A
-id (PK)
-name
Table B
-table_a_id (PK, FK)
-address
When I do an insert on table B, the database check if value for column
“table_a_id” exists in table A
But, if I do an update of column “address” of
Hi
I'm a postgres novice so
I have this fairly simple table
-
device integer not null,
group integer not null,
datum timestamp without time zone not null,
val1 numeric(7,4) not null default 0.000,
val2 numeric(7,4) not null default 0.000
I recently ran a query against our production database and saw several
disused indexes. Is there a performance harm in having disused
indexes out there?
Of course, I will be checking our code base and with developers to
ensure that these indexes aren't being used programmatically to
prevent
try to have as few indexes as possible and do your inserts inside
transactions in batches, rather than one-by-one as individual statements.
That is the main problem. I use now few index as possible. Unfortunately the
one-by-one INSERT is nature of or system. To join (batch) inserts is require
Kevin Grittner wrote:
Rollback activity? What rollback activity? When you're doing what?
What is the exact message?
I mean here some kind of option to save reources.
For example mysql has table (storage) type where no transaction support
(rollback) in. This make the all server faster and use
On Wed, Oct 19, 2011 at 9:24 AM, Elisa elisa.derick...@shoutlet.com wrote:
I recently ran a query against our production database and saw several
disused indexes. Is there a performance harm in having disused
indexes out there?
Sure there is, they'll slow down writes and use more disk space.
On Wed, 2011-10-19 at 08:03 -0700, alan wrote:
So I thought I’d just run this once (via cron) every morning.
BEGIN;
DROP INDEX data_unique;
UPDATE data SET datum = (data.datum + interval '24 hours');
CREATE UNIQUE INDEX data_unique ON public.data USING BTREE
On 10/19/2011 05:46 PM, d.davo...@mastertraining.it wrote:
My colleagues are asking how many Cluster Databases (initdb) can I
create and run on a single server. I mean, supposed my server has the
resources, can I create 100 or even 200 Cluster Databases?
Yep. It won't be fast, but it'll work.
On 10/20/2011 02:55 AM, kzsolt wrote:
try to have as few indexes as possible and do your inserts inside
transactions in batches, rather than one-by-one as individual statements.
That is the main problem. I use now few index as possible. Unfortunately the
one-by-one INSERT is nature of or
18 matches
Mail list logo