-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Dennis Gearon wrote:
| Gaetano Mendola wrote:
|
| Dennis Gearon wrote:
|
| I am designing something that may be the size of yahoo, google, ebay,
| etc.
|
| Just ONE many to many table could possibly have the following
| characteristics:
|
|
No problem at all.
It's easy to automate the table linking process.
I have a table in access that holds - among other things - the internal
and external name of my linked tables, in which database, schema and
server they locate.
[snip]
Thank you very much for the information.
Regards
Henry
I really appreciate these type of high-quality anwsers, thank you.
Tim
On 10/21/2004 10:27 AM, [EMAIL PROTECTED] wrote:
Hello
MySQL has information about several storage engines. MEMORY to handle
temporary tables, InnoDB to handle transactions and which also can split
its table data over
Hello,
As the amount of simultaneous users of my database grows (25 users
sometimes, PGSQL 7.4.5), deadlocks are unfortunately more and more
frequent. I guess this is due to the FKs problem with Postgresql.
I have tried to correct that by adding a SET CONSTRAINTS ALL DEFERRED
in every trigger
Guys,
I have an opening currently for the following position. If interested,
email me at john.wells__replace_this_with_at__timco.aero. Although relo
is stated as not covered, I may be able to fight for that given a very
qualified candidate.
Company:TIMCO Aviation Services
Location:
thanks for your replay. This approach sounds very comfy. As I read the
documentation this is kind of a transaction sequence or better a
unique transaction id. Am I right with this? So every row inserted or
updated within the same transaction is tagged with the same xmin.
Is there any information
On Fri, 22 Oct 2004, Philippe Lang wrote:
I have tried to correct that by adding a SET CONSTRAINTS ALL DEFERRED
in every trigger and function, hoping it would solve my problem. Maybe
it helped, but it did not solve anything.
Note that set constraints all deferred does nothing unless you made
Great Idea! When I get that far, I will try it.
Gaetano Mendola wrote:
snip
For partion in some way I don't mean only split it in more tables. You
can use some available tools in postgres and continue to see this table
as one but implemented behind the scenes with more tables.
One usefull and
Stephan Szabo [EMAIL PROTECTED] writes:
On Fri, 22 Oct 2004, Philippe Lang wrote:
I don't know if anyone has a better idea, but I would like to try taking
away some FKs in my schema. My problem is that I really don't know which
one to delete. There are over 40 tables. Are there rules to do
Ruediger Herrmann [EMAIL PROTECTED] writes:
Is there any information wether this approach is future proof?
[ shrug... ] As much as anything that's not specified by the SQL
standard is around here. We have no plans to replace MVCC, and
xmin/xmax are a pretty fundamental part of that.
I've worked with Oracle, Interbase, and Informix. PostgreSQL is the most
SQL spec compliant of any of them, whether the spec is 89, 92, or 03. I
have not worked with MySQL.
Rick
But it is possible to use multiple indexes on dates, and that is why the one at the
bottom works, right?
Would a single index get used for
SELECT appointment
FROM the_table
WHERE 0 (date_mask date_range);
Tom Lane wrote:
No, an index can be used for one or the other. Since we don't yet have
Sorry folks,
the Slony-I team has produced a great product, but the project
management (that's mostly me here) sucks big time!
Shortly after giving Chris Browne green light for the 1.0.4 announcement
we found a way to guard against bug #896. That being a really bad one I
decided to stop the
Dennis Gearon [EMAIL PROTECTED] writes:
But it is possible to use multiple indexes on dates, and that is why the one at the
bottom works, right?
No, it is possible to use multiple conditions that are relevant to a
single index. A range query like where x = lobound and x = hibound
works very
Hi,
I have an installation of Postgres 7.4.2 on SuSE 9.1. This version
of SuSE comes with a binary for plperl and several other postgres
procedural languages. All the others, including plpgsql install without
a problem, but executing:
createlang -u postgres plperl template1
produces the
On 10/22/2004 11:29 AM, Ed L. wrote:
Wow. First, thanks again for all your efforts, Jan. Second, I'm
disappointed to hear the slony author and lead developer is leaving the
slony leadership. When is that going to happen? And what does that mean
with respect to your future involvement in
On Fri, Oct 22, 2004 at 12:13:12PM -0400, Eric E wrote:
Hi,
I have an installation of Postgres 7.4.2 on SuSE 9.1. This version
of SuSE comes with a binary for plperl and several other postgres
procedural languages. All the others, including plpgsql install without
a problem, but
Eric E [EMAIL PROTECTED] writes:
createlang: language installation failed: ERROR: could not load library
/usr/lib/postgresql/plperl.so: libperl.so: cannot open shared object
file: No such file or directory
The file, however, is there:
# ls -l /usr/lib/postgresql/plperl.so
-rwxr-xr-x 1
Greetings:
While working with plpgsql and triggers, I've been using TG_NAME to display
the trigger name at various points where I need to raise an exception and
return a message. I was thinking how nice it would be if I could display the
line number as well. Is there a special variable that
On Thu, Oct 21, 2004 at 03:40:23PM -0400, John Wells wrote:
Guys,
My boss has been keeping himself busy reading MySQL marketing pubs,
and came at me with a few questions this morning regarding PostgreSQL
features (we're currently moving to PostgreSQL).
I should point out that there's a
On 10/21/2004 3:40 PM, John Wells wrote:
Guys,
My boss has been keeping himself busy reading MySQL marketing pubs,
and came at me with a few questions this morning regarding PostgreSQL
features (we're currently moving to PostgreSQL).
While I don't think either are really that important for our
The site seems to be down Tom.
Tom Lane wrote:
snip
I don't see any indexable operator there at all. You might care to read
http://developer.postgresql.org/docs/postgres/xindex.html
which describes the behaviors Postgres indexes have.
regards, tom lane
Wow. First, thanks again for all your efforts, Jan. Second, I'm
disappointed to hear the slony author and lead developer is leaving the
slony leadership. When is that going to happen? And what does that mean
with respect to your future involvement in slony?
Ed
On Friday October 22 2004
I have come up with a simple query that runs horribly depending on the
number of columns selected.
select order_lines.*
from orders, order_lines
where orders.merchant_order_id = '11343445' and
order_lines.order_id=orders.order_id;
merchant_order_id is indexed.
order_id is indexed.
Tables are
Hi Steve and Tom,
Thanks for the tip, I was clearly not reading the error message closely
enough.
I copied libperl.so into /lib, and now everything works.
Many thanks,
Eric
Steve Atkins wrote:
On Fri, Oct 22, 2004 at 12:13:12PM -0400, Eric E wrote:
Hi,
I have an installation of Postgres 7.4.2
Cott Lang [EMAIL PROTECTED] writes:
- Sort (cost=nan..nan rows=2023865 width=1257)
What PG version is this? My recollection is we fixed such a thing quite
some time ago ...
regards, tom lane
---(end of broadcast)---
Oops, sorry - guess I left that out - 7.4.5. :)
On Fri, 2004-10-22 at 12:28, Tom Lane wrote:
Cott Lang [EMAIL PROTECTED] writes:
- Sort (cost=nan..nan rows=2023865 width=1257)
What PG version is this? My recollection is we fixed such a thing quite
some time ago ...
Cott Lang [EMAIL PROTECTED] writes:
Oops, sorry - guess I left that out - 7.4.5. :)
Hmm ... I can't duplicate any misbehavior here. Are you using
nondefault values for any planner parameters? (particularly sort_mem,
random_page_cost, effective_cache_size)
regards, tom
what does this message mean?
thanks,
--h
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
Well, it seems that i have to build the scan operator myself. Even the
FunctionScan will make all the function calls and stores the result in a
tuuplestore. So, all the delay will be occured only at the first function
invocation.
--h
Alvaro Herrera [EMAIL PROTECTED] wrote in message
On Fri, Oct 22, 2004 at 09:36:10AM -0400, Jan Wieck wrote:
wealth. And as long as Afilias is using Slony-I in production, Andrew
Sullivan will not let me do whatever I want if there's a severe problem
nobody else can fix.
Or someone around here will, anyway. I might get hit by a wayward
shared_buffers = 16384
sort_mem = 8192
random_page_cost = 2
effective_cache_size = 3932160
On Fri, 2004-10-22 at 13:32, Tom Lane wrote:
Cott Lang [EMAIL PROTECTED] writes:
Oops, sorry - guess I left that out - 7.4.5. :)
Hmm ... I can't duplicate any misbehavior here. Are you using
Cott Lang [EMAIL PROTECTED] writes:
sort_mem = 8192
random_page_cost = 2
effective_cache_size = 3932160
effective_cache_size 30Gb ? Seems a tad high ;-)
However, I set up a dummy test case on 7.4.5 and don't see any overflow.
regression=# create table z1(f1 char(1253));
CREATE TABLE
The Slony-I team http://slony.info/ is happy to present the 1.0.5
release.
The release tarball is available for download
http://developer.postgresql.org/~wieck/slony1/download/slony1-1.0.5.tar.gz
See the HISTORY-1.0 file for a detailed list of changes.
--
let name=cbbrowne and
Christopher Browne wrote:
Oops! Gaetano Mendola [EMAIL PROTECTED] was seen spray-painting on a wall:
Chris Browne wrote:
The Slony-I team is proud to present the 1.0.4 release of the most
advanced replication solution for the most advanced Open Source
Database in the world.
The release
On Fri, 22 Oct 2004 14:18:52 -0400, Jan Wieck [EMAIL PROTECTED] wrote:
That multiple hosts sounds that he came across the NDB cluster stuff
that will become available in MySQL someday. Be aware that this new
table handler will to my knowledge NOT support foreign keys. So the
enforcement of
Hicham G. Elmongui [EMAIL PROTECTED] writes:
what does this message mean?
libpq is unhappy because the DataRow ('D') message had a field count
different from the preceding RowDescription ('T') message. How did you
manage that?
regards, tom lane
I've installed both 32-bit and 64-bit executables of 7.4.5 on ia64 running
HP-UX B.11.23. The 32-bit version works fine and accepts both local and
remote connections. The 64-bit version, however, rejects any/all attempts
to connect with the following message:
FATAL: no pg_hba.conf entry
Ed L. [EMAIL PROTECTED] writes:
I've installed both 32-bit and 64-bit executables of 7.4.5 on ia64 running
HP-UX B.11.23. The 32-bit version works fine and accepts both local and
remote connections. The 64-bit version, however, rejects any/all attempts
to connect with the following
Tom Lane wrote:
Since we don't yet have bitmap combining of indexes...
^^^
Are you trying to tell us something ? :-)
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Scott Marlowe wrote:
On Wed, 2004-10-20 at 08:06, Dan Pelleg wrote:
I'm trying to access a table with about 120M rows. It's a vertical version
of a table with 360 or so columns. The new columns are: original item col,
original item row, and the value.
I created an index:
CREATE INDEX idx on table
On Fri, 2004-10-22 at 14:19, Tom Lane wrote:
Cott Lang [EMAIL PROTECTED] writes:
sort_mem = 8192
random_page_cost = 2
effective_cache_size = 3932160
effective_cache_size 30Gb ? Seems a tad high ;-)
It's a 32GB machine with nothing else running on it except PG, buffers
hover around 31GB
How can I combine these two queries?
# select viewerid,count(*) from viewer_movies group by viewerid order by viewerid;
viewerid | count
--+
22964835 | 3055
22964836 | 1291
22964837 | 3105
22964838 |199
planb=# select name from xenons where id = 23500637;
name
Cott Lang [EMAIL PROTECTED] writes:
Fiddling with the above values, only setting sort_mem absurdly large
easily causes NAN.
Ah. I see an overflow case for sort_mem exceeding 1Gb; that's probably
what you tickled.
I've fixed this in HEAD, but it doesn't seem worth back-patching.
If you care,
Title: RE: [GENERAL] combining two queries?
Try
select a.name,count(*) from
xenons as a,
viewer_movies as b
where a.id = b.viewerid
group by a.name order by a.name;
-Original Message-
From: Mark Harrison [mailto:[EMAIL PROTECTED]]
Sent: Friday, October 22, 2004 4:55 PM
To: [EMAIL
On Friday October 22 2004 5:11, Tom Lane wrote:
Ed L. [EMAIL PROTECTED] writes:
I've installed both 32-bit and 64-bit executables of 7.4.5 on ia64
running HP-UX B.11.23. The 32-bit version works fine and accepts both
local and remote connections. The 64-bit version, however, rejects
46 matches
Mail list logo