Hello,
Note: I know that its not a very good db design. But what if a senario
comes in front of you?
I have created an uncommon database design. Which is as follows:
Created 2 Tables :- Emp1 and Emp2
TableA with 2 Attributes
A1 and A2.
A1 is the primary key.
TableB with 2 Attributes
B1
Am Montag, 24. Juli 2006 14:53 schrieb Mans:
Isnt it a crazy thing??
Yes, but with deferrable constraints and transactions blocks, it should be no
problem to manage the data.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of
Hi Peter,
Can you please give some detailed information about it?
Regards,
Mans
Peter Eisentraut wrote:
Am Montag, 24. Juli 2006 14:53 schrieb Mans:
Isnt it a crazy thing??
Yes, but with deferrable constraints and transactions blocks, it should be no
problem to manage the data.
--
Hi,
Using this query plan, an extra uid shows up in this example. We are in the
process of upgrading from v810 to v814. Does anyone see anything wrong with
this query plan that might be causing a problem?
Index Scan using pk_recent_projects on recent_projects (cost=0.00..5.81
rows=1
On Mon, 24 Jul 2006, Mans wrote:
Hello,
Note: I know that its not a very good db design. But what if a senario
comes in front of you?
I have created an uncommon database design. Which is as follows:
Created 2 Tables :- Emp1 and Emp2
TableA with 2 Attributes
A1 and A2.
A1 is the
Thaks to all who helped on this one, for I was going insane.
I am now auto_vacuuming every 30 seconds, and have cheanged the
para,eters so the vacuuming takes place much more aggressively.
Performance has increased and table size appears to have been addressed.
For the newbies like myself who
I have had to bump the stats on a partitioned table in order to get the
planner to use an index over a seqscan. This has worked well in making
the system perform where it needs to as it reduced one query's execution
from 45 seconds to 1 second.
The one problem I have run into is that when I
Hi all, I am trying to backup a psql database in one system(Debian), and restore it to another system(ubuntu) which has a fresh installed psql db. However, I got the following errors. Can anyone give me some help on solving it. Many thanks.
-OME Restore- \_ Extracting
It looks like it's a user configuration issue. I have hit user setup issues
while restoring DB's before and generally I find it useful to create the
Users and/or Groups manually on the new server first before restoring the
DB's whenever I hit problems like that. Try syncing the users manually,