expected performance that
is much more meaningful then my ramble above. :)
Terry
Terry Fielder
te...@greatgulfhomes.com
Associate Director Software Development and Deployment
Great Gulf Homes / Ashton Woods Homes
Fax: (416) 441-9085
Bill Thoen wrote:
I'm building a national database
at and then kill a specific bad query?
Maybe this is not missing functionality, it can do it and I just don't
know how. Anybody want to wisen me up? :)
Terry
Terry Fielder
te...@greatgulfhomes.com
Associate Director Software Development and Deployment
Great Gulf Homes / Ashton Woods Homes
Fax
give you what you want
if you want to see all SQL statements.
Terry
Terry Fielder
[EMAIL PROTECTED]
Associate Director Software Development and Deployment
Great Gulf Homes / Ashton Woods Homes
Fax: (416) 441-9085
Dave Potts wrote:
I am using a 3rd front end to generate postgres requests
Snip
Howard Cole wrote:
Hi Marijn, Andreas,
I think Andreas is right, note the ordering of characters in the above
example as [ ^] rather than [^ ].
So if the '^' is taken as literal '^', can I check for the beginning
of a string in the brackets,
Why do you need to? Check for the
Does the remote server have the relevant port opened up in its firewall?
Is postgres set to allow TCP/IP connections in the postgresql.conf?
Terry
Terry Fielder
[EMAIL PROTECTED]
Associate Director Software Development and Deployment
Great Gulf Homes / Ashton Woods Homes
Fax: (416) 441-9085
the 8.2 resolves index locking issues was the concern for an 8.1 install.
Should I add a primary key column of serial? Will that help?
If anyone has any ideas it would be appreciated.
--
Terry Fielder
[EMAIL PROTECTED]
Associate Director Software Development and Deployment
Great Gulf Homes
root 10 -5 000 D1 0.0 22:59.43 kjournald
4949 root 15 0 12996 1336 792 S1 0.0 38:54.10 top
--
Terry Fielder
[EMAIL PROTECTED]
Associate Director Software Development and Deployment
Great Gulf Homes / Ashton Woods Homes
Fax: (416) 441-9085
Responses below.
Terry Fielder
[EMAIL PROTECTED]
Associate Director Software Development and Deployment
Great Gulf Homes / Ashton Woods Homes
Fax: (416) 441-9085
Tom Lane wrote:
Terry Fielder [EMAIL PROTECTED] writes:
Under pg 7.x the system performed fine.
In 8.1.9, the insert
My 2 cents:
I used to get a lot of these sharelock problems.
Users using different records, but same tables in different order.
(apparently 7.x was not as good as 8.x at row level locking)
I was advised to upgrade from 7.x to 8.x
I did, and all those sharelock problems went away.
Terry
Terry
You may encounter many things in life which you may regret having done.
Converting from M$ SQL to PostgreSQL is probably *not* one of them.
Terry
Terry Fielder
[EMAIL PROTECTED]
Associate Director Software Development and Deployment
Great Gulf Homes / Ashton Woods Homes
Fax: (416) 441-9085
Tom Lane wrote:
Arnaud Lesauvage [EMAIL PROTECTED] writes:
When trying to import a 20M rows csv file into PostgreSQL, I
get :
ERROR: out of memory
État SQL :53200
Détail :Failed on request of size 1073741823.
Contexte : COPY tmp, line 1
Can you put together a self-contained
?
Thanks in advance
--
Terry Fielder
[EMAIL PROTECTED]
Associate Director Software Development and Deployment
Great Gulf Homes / Ashton Woods Homes
Fax: (416) 441-9085
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
7.4.3
And the records are gone from pg_locks, how much time after the
deadlock do I have before they are purged?
Terry Fielder
[EMAIL PROTECTED]
Associate Director Software Development and Deployment
Great Gulf Homes / Ashton Woods Homes
Fax: (416) 441-9085
Tom Lane wrote:
Terry
a .pgpass file in the users home directory
(if ident not available, but you *need* to think about the permissions
of this file and ramifications)
Terry
Terry Fielder
[EMAIL PROTECTED]
Associate Director Software Development and Deployment
Great Gulf Homes / Ashton Woods Homes
Fax: (416) 441
Is there an chance the rows are being inserted in a transaction that
fails and rolls back? Maybe look at all the lines that were inserted
with that order, and try them manually in psql, character for character,
and see if an error pops up for any of the lines?
Terry Fielder
[EMAIL PROTECTED
By regular PostgreSQL do you mean a PostgreSQL 7.x install?
Terry Fielder
[EMAIL PROTECTED]
Associate Director Software Development and Deployment
Great Gulf Homes / Ashton Woods Homes
Fax: (416) 441-9085
Matthew Hixson wrote:
http://www.enterprisedb.com/news_events/press_releases/04_24_06
SELECT id, get_category_text_path(id)
FROM category
WHERE id IN (
SELECT c.id
FROM category AS c
ORDER BY c.rank
LIMIT 5
)
Terry Fielder
[EMAIL PROTECTED]
Associate Director Software Development and Deployment
Great Gulf Homes / Ashton Woods Homes
Fax: (416) 441-9085
Markus
was the goal you
requested)
3) In SQL there is almost always more then 1 way of doing something,
you have now seen 2. There may be more, possibly even better ways.
Experts care to comment? :)
Terry Fielder
[EMAIL PROTECTED]
Associate Director Software Development and Deployment
Great Gulf Homes / Ashton
I second Tom:
badblocks and memtest86 are what I use and works great on all kinds of
hardware. You don't even need a specific OS for memtest86 because you
can make a bootable floppy and test any old piece of hardware it recognizes.
Terry
--
Terry Fielder
[EMAIL PROTECTED]
Associate
searched our list archives?
http://archives.postgresql.org
--
Terry Fielder
[EMAIL PROTECTED]
Associate Director Software Development and Deployment
Great Gulf Homes / Ashton Woods Homes
Fax: (416) 441-9085
---(end of broadcast
application developer, let's not do that.
Terry
regards, tom lane
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
--
Terry Fielder
[EMAIL PROTECTED]
Associate Director Software
PROTECTED] Yahoo!: yscrappy ICQ: 7615664
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
--
Terry Fielder
[EMAIL PROTECTED]
Associate Director Software Development
.
Perhaps there are some nuances that I am not aware of. But that is how
things ought to behave, if I were king of the forest.
-Original Message-
From: [EMAIL PROTECTED] [mailto:pgsql-general-
[EMAIL PROTECTED] On Behalf Of Terry Fielder
Sent: Wednesday, October 19, 2005 12:37 PM
('Danniel ')
go
insert into bar values ('Danniel ')
go
select * from foo,bar where foo.col1=bar.col1
go
Result set:
Danniel Danniel
-Original Message-
From: Terry Fielder [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 19, 2005 1:39 PM
To: Dann Corbit
Cc: Marc G
, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
--
Terry Fielder
[EMAIL PROTECTED]
Associate Director Software Development and Deployment
Great Gulf Homes / Ashton Woods Homes
Fax: (416) 441-9085
---(end
something other than space as the pad character?
If so, what character is that (and why choose it over space)?
If not, then PostgreSQL is clearly returning the wrong results.
-Original Message-
From: Terry Fielder [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 19, 2005 2:02 PM
To: Dann
).
mysql SELECT INTERVAL(23, 1, 15, 17, 30, 44, 200);
- 3
mysql SELECT INTERVAL(10, 1, 10, 100, 1000);
- 2
mysql SELECT INTERVAL(22, 23, 30, 44, 200);
- 0
--
Terry Fielder
[EMAIL PROTECTED]
Associate Director Software Development and Deployment
Great Gulf
. Please let me
know
Note: i can able to connect with my local ip address. The issue which
i faced when i access through the public ip address.
--
Terry Fielder
[EMAIL PROTECTED]
Associate Director Software Development and Deployment
Great Gulf Homes / Ashton Woods Homes
Fax: (416) 441-9085
or cast the expression
I have tried (bit) 0, bit(0), bit 0, etc but have not found a way to do
casting. Can anyone help me to set a default value for a bit datatype
field?
Thanks
Terry Fielder
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 1
29 matches
Mail list logo
