column's datatypes do not match
[ \ /
[ >X< Christian Fowler | spider AT viovio.com
[ / \ http://www.viovio.com | http://www.tikipro.org
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an
f course dbtuning is running on postgres ;-)
[ \ /
[ >X< Christian Fowler | spider AT viovio.com
[ / \ http://www.viovio.com | http://www.tikipro.org
---(end of broadcast)---
TIP 8: explain analyze is your friend
forge )
Execution stalls on reaching pg_connect() .
can you give some pointers to this. I have tried all docs that I could :(
-Sukhdeep
[ \ /
[ >X< Christian Fowler | spider AT viovio.com
[ / \ http://www.viovio.com | http://www.tikipro.org
---(end o
after the live
servers.
[ \ /
[ >X< Christian Fowler | spider AT viovio.com
[ / \ http://www.viovio.com | http://www.tikipro.org
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
7;@'
The explicit join syntax was freaky for me too at first, but after
several years, I prefer it now, since you can easily control your left
outer joins
[ \ /
[ >X< Christian Fowler | spider AT viovio.com
[ / \ http://www.viovio.com | http://www.tikipro.org
---(end of broadcast)---
TIP 8: explain analyze is your friend
ED] so that your
message can get through to the mailing list cleanly
[ \ /
[ >X< Christian Fowler | spider AT viovio.com
[ / \ http://www.viovio.com | http://www.tikipro.org
---(end of broadcast)---
TIP 2: you can get off all
lines) and UNICODE to UTF-8.
--
Markus Bertheau <[EMAIL PROTECTED]>
---(end of broadcast)---
TIP 8: explain analyze is your friend
[ \ /
[ >X< Christian Fowler | spider AT viovio.com
[ / \ http://www.vi
Fowler <[EMAIL PROTECTED]> writes:
[shell]$ env
PGCLIENTENCODING=UNICODE
LANG=en_US.UTF-8
db=# \encoding
UNICODE
I was more concerned about the database encoding, which the above
doesn't prove. Try "SHOW server_encoding"
regards, tom lane
[ \ /
[ &
[shell]$ env
PGCLIENTENCODING=UNICODE
LANG=en_US.UTF-8
db=# \encoding
UNICODE
On Mon, 15 Nov 2004, Tom Lane wrote:
Christian Fowler <[EMAIL PROTECTED]> writes:
After much wrestling, it appears the hex byte sequence #bfef in a VARCHAR
column causes a truncated COPY line to be written (and th
ort each copy row in it's own
transaction so 5+ million copied rows don't fail for 6 bogus ones. Perhaps a
--this_is_an_emergency_so_please_do_everything_you_can_to_restore_as_much_as_possible
option.
If any of the core dev's want some small debug dumps I created, I'd be
happy t
p fiddling and it should hopefully start up.
On Fri, 29 Oct 2004, Ivan Dimitrov wrote:
Hi list
This is my first post here, and I've searched google but couldn't find the
solution.
I'm trying to run pg_autovacuum on all my databases. All my Debian sarge
machines use version 7.4.5-
acter varying(200) |
mod_date | timestamp without time zone |
pc_char | character varying(4)|
dim_char | character varying(16) |
[EMAIL PROTECTED] root]# env |grep LANG
LANG=en_US.UTF-8
On Wed, 20 Oct 2004, Weiping wrote:
Christian Fowler wrote:
I'm running a larg
even waste time installing the NIC's I would like a sense of how
hard it is to get postgres to use that kind of a connection vs over the
Internet. We are looking to increase communication speed between the web
servers and database server as much as possible.
Thanks
Kent Anderson
[ \ /
[ &g
here is a short
row (by two), and two fields in on the *next* line is indeed a "4"
Both seem to have the same problem - incomplete COPY row data. any ideas?
[ \ /
[ >X< Christian Fowler | [EMAIL PROTECTED]
[ / \ http://www.viovio.com | http://www.tikipro.org
Thanks Tom, it appears that was the issue. Bruce, it would appear it
was at some point? Glad to hear it's now insensitive.
On Sun, 17 Oct 2004, Bruce Momjian wrote:
FYI, it is not case-sensitive in current CVS.
Tom Lane wrote:
Christian Fowler <[EMAIL PROTECTED]> writes:
I have \set
main=# rollback;
ROLLBACK
host.domain=# begin;
BEGIN
host.domain=# update foo set foo_type_id = 3 where foo_id=20234;
UPDATE 1
host.domain=# rollback;
ROLLBACK
host.domain=# \q
[ \ /
[ >X< Christian Fowler | [EMAIL PROTECTED]
[ / \ http://www.viovio.com | http://www.tikipro.org
---
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
[ \ /
[ >X< Christian Fowler | [EMAIL PROTECTED]
[ / \ http://www.viovio.com | http://www.tikipro.org
---(end of broadcast)
Igor,
I would recommend you investigate LVM:
http://www.tldp.org/HOWTO/LVM-HOWTO/
This enables you to string multiple physical units into a single volume -
as well as expand and grow the volume. I am unsure about postgres
consequences of this for as much data as you have, so I will leave it up
I would like to also add that I've been a sysadmin for quite some time, and
I've been designing databases for quite some time as well. I'm no idiot, I
just can't find the bottleneck here (if one does in fact exist). So in light
of this, please send me some suggestions I can work with.
Here are thr
Hi Shane,
As many others have alluded to - performance like this is almost always
attributable to your queries not using an index. Be it on Oracle, Mysql,
or postgres, i have seen this problem popup often.
Also, could you tell us what language you are using, and if you are using
a DB abstractio
20 matches
Mail list logo
