Thomas Kellerer wrote:
> zeljko, 04.02.2013 10:35:
>> Edson Richter wrote:
>>
>>> Hi!
>>>
>>> Assumptions: PostgreSQL 9.2.2, Win64, already run vacumm full freeze
>>> analyze. No problems in the database. I know there are 1247 records to
>&g
m parcela
> where id not in (select parcela_id from cadastroservicoparcela);
I'm always using
WHERE NOT id in (blabla) and never had such problems.
zeljko
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
eoslib.
Those who bypass libpq probably uses odbc connections or similar.
zeljko
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
pasman pasmański wrote:
> Hello. Is postgresql able to compress data sent to the client?
>
No. You can use ssh tunnel (with ssh compression enabled) under linux, but
same thing can be applied via putty under windows.
zeljko
--
Sent via pgsql-general mailing list (pgsql-general@postgres
zeljko wrote:
> SELECT convert(myfield,'LATIN2','WIN1250') FROM tbl;
>
> ERROR: character 0x828e of encoding "MULE_INTERNAL" has no equivalent in
> "WIN1250"
>
> I know I have few characters like this one in table with about 1.000.000
&
SELECT convert(myfield,'LATIN2','WIN1250') FROM tbl;
ERROR: character 0x828e of encoding "MULE_INTERNAL" has no equivalent in
"WIN1250"
I know I have few characters like this one in table with about 1.000.000
rows.
How to avoid such error and show eg. ? instead of error , or how to replace
such
Michael Fuhr wrote:
> On Fri, Sep 15, 2006 at 07:58:54PM +0200, zeljko wrote:
> So you were doing SSL over an SSH tunnel. That explains why
> compression didn't seem to be working -- SSH was trying to compress
> essentially random data (the SSL-encrypted data), and random da
Michael Fuhr wrote:
> What does a sniffer like tcpdump or wireshark/ethereal show? Let's
> see how much data is being sent over a compressed vs. uncompressed
> connection and how long the data transfers are taking.
ARGH IT WORKS ! :)
postgresql.conf contained ssl=on , so ssl=off = s
Michael Fuhr wrote:
> On Fri, Sep 15, 2006 at 06:34:48PM +0200, zeljko wrote:
>> I'm testing over DSL line (test server have 256k Upload and 1MB
>> download). Results are based on this connection.
>> Server : PIV 3Ghz HT, 1GB RAM. (DSL D 1MB U 256k)
>> Client : PI
Michael Fuhr wrote:
> On Fri, Sep 15, 2006 at 09:52:04AM -0600, Michael Fuhr wrote:
>> On Fri, Sep 15, 2006 at 05:37:50PM +0200, zeljko wrote:
>> > But, when I try (via tunnel, explained above)
>> > psql -p 5400 -h localhost mydatabase
>> > it connects and wo
Michael Fuhr wrote:
> That's a tenuous conclusion; it assumes that the data transfer is
Are you trying to say that data won't be compressed ?
> what's taking all the time. Query planning and execution and
> client-side processing must also be taken into account. Using a
> sniffer to observe th
Michael Fuhr wrote:
> On Fri, Sep 15, 2006 at 03:38:01PM +0200, zeljko wrote:
>> Tom Lane wrote:
>> > zeljko <[EMAIL PROTECTED]> writes:
>> >> Is there any plans (or somebody already working on) to see compressed
>> >> protocol in 8.2 ?
>>
Tom Lane wrote:
> zeljko <[EMAIL PROTECTED]> writes:
>> Is there any plans (or somebody already working on) to see compressed
>> protocol in 8.2 ?
>
> Why bother? Run your session through an ssh tunnel and ask it to
> compress.
hm... tunneling works as expect
Tom Lane wrote:
> zeljko <[EMAIL PROTECTED]> writes:
>> Is there any plans (or somebody already working on) to see compressed
>> protocol in 8.2 ?
>
> Why bother? Run your session through an ssh tunnel and ask it to
> compress.
I saw it on TODO list, not
Is there any plans (or somebody already working on) to see compressed
protocol in 8.2 ?
zac
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
ID shouldn't contain any additional informations (like order). It's ID. Use
another field for sorting.
At 16:33 22.9.2000 , Abe Asghar wrote:
>Hi everyone,
>
>I have built a database that uses int4 as the unique identifier for a news
>database.
>
>Therefore an article has a identifier 1, the next
Connect to the main pg CVS, and then go to interfaces/jdbc or something
like that. There is a Web interface, too.
At 04:33 20.9.2000 , Mike Cannon-Brookes wrote:
>I've looked there but the site seems seriously out of date. Hasn't been
>updated since June 1999? There are CVS commits that date from
Me too, and I'm getting some stuff two times, like I'm double subscribed
(which I shouldn't be). Sometimes it takes few days for messages to appear
on list etc.
At 10:12 14.9.2000 , [EMAIL PROTECTED] wrote:
>I was just about to ask the same question...
>
>med vänlig hälsning
>/Dana
>
>-Origin
c...) in the JDBC Explorer. Yet the
>> driver lets me manipulate these unseen objects when I execute sql
>> statements against the database. Problem is, I'd like to see all my
>> database objects in the JDBC Explorer GUI, not just the system index.
>>
>> Ha
2 to 15 (in case
UNICODE is OK).
v
Zeljko Trogrlic
Aeris d.o.o.
Sv. Petka 60 b, HR-31000 Osijek, Croatia
Tel: +385 (31) 53 00 15
Email: mailto:[EMAIL PROTECTED]
ICODE support?
* Do I have to set somethinh in Java in order to get UNICODE working?
* Which method should I use to read UNICODE data?
I have to enter multilingual data so I can't switch to national character set.
v
Zeljko Trogrlic
A
Manual says you should use it after initial data entry, after entering a
large amount of rows and periodically.
At 23:02 4.9.2000 , Zlatko Calusic wrote:
>Tom Lane <[EMAIL PROTECTED]> writes:
>
>> Zlatko Calusic <[EMAIL PROTECTED]> writes:
>> > It is now NOT using the index, and I don't understan
22 matches
Mail list logo
