Thank you for the clarification.
El 5/10/2017 9:27 AM, "Robert Haas" escribió:
> On Mon, Sep 18, 2017 at 5:30 PM, guedim wrote:
> > I am working with Postgres9.6 with a Master/Slave cluster replication
> using
> > Streaming replication.
> > I would like to add a new Slave server database but th
proposal. I'm really enjoying to work in the Postgres internals
and at least I'd like to finish this PATCH.
Any suggestion on what do I need to read, similar cases, advices, etc?
Again thank you very much for your time and you invaluable help.
Mario
2016-10-14 15:22 GMT+02:00 Tom Lane
b2cdb872b5b5bd65606f5bce334d2477b2afc5/postgis/postgis_module.c#L128>
and
have multiple signal handlers: one for the Postgres using
StatementCancelHandler and one for the python code. How does it sound?
Thank you again for your time :)
2016-10-14 12:01 GMT+02:00 Heikki Linnakangas :
> On
Hello everyone :).
First of all, I want to introduce me to this list. My name is Mario de
Frutos and I work at CARTO :)
I come here asking for some advice/help because we're facing some
unexpected behavior when we want to interrupt functions doing CPU intensive
operations in plpython.
Am 22.11.2013 16:15, schrieb Tom Lane:
[ memo to self: never, ever accept another contrib module whose name
isn't a plain SQL identifier ]
Well, in that case and since this is a rarely used extension (I guess
so), maybe it would be the best to simply rename that extension to
uuidossp (or what
Am 01.12.2010 15:37, schrieb Rob Wultsch:
"For beginners, a useful startup option is --safe-updates (or
--i-am-a-dummy, which has the same effect). This option was introduced
in MySQL 3.23.11. It is helpful for cases when you might have issued a
DELETE FROM tbl_name statement but forgotten the WH
> (Aside: presumably we could walk thru the string destructively,
> in-place, swapping bytes; I think that would be theoretically
> quickest...)
Hmmm... I guess it will not work für UTF-8 or any other multibyte charset
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To mak
generate too much wal data, so this kind of compression
would be quite helpful.
Regards,
Mario
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
lated updates.
Best regards,
Mario Weilguni
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
Marko Kreen schrieb:
On 6/16/08, Mario Weilguni <[EMAIL PROTECTED]> wrote:
Marko Kreen schrieb:
On 6/16/08, Mario Weilguni <[EMAIL PROTECTED]> wrote:
Could someone using the pgcrypto extension please verify this?
SELECT encode(digest(null, 'md5'::text
Marko Kreen schrieb:
On 6/16/08, Mario Weilguni <[EMAIL PROTECTED]> wrote:
Could someone using the pgcrypto extension please verify this?
SELECT encode(digest(null, 'md5'::text), 'hex');
or
SELECT digest(null, 'md5');
Takes a few seconds, and then
d access to memory
location 0.
Best regards,
Mario Weilguni
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
>
> open cursorSrc for select * from testtable;
>
> We cannot substitude "select * from testtable" with a variable.
>
> Is there another way to handle it?
>
> Thank you for your help. :-)
>
open cursorSrc for execute queryStr; should work fine
Regards
Mario Weilguni
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
Mike schrieb:
Hello,
I’m new to the core PostgreSQL code, so pardon the question if the
answer is really obvious, and I’m just missing it, but I’ve got a
relatively large web application that uses PostgreSQL as a back-end
database, and we’re heavily using memcached to cache frequently
acces
Tom Lane schrieb:
"Jonah H. Harris" <[EMAIL PROTECTED]> writes:
I've run into a couple cases now where it would be helpful to easily
assign an already-existing unique index as a primary key.
You need to present a more convincing use-case than this unsupported
assertion. There's hardly
Heikki Linnakangas schrieb:
Mario Weilguni wrote:
I cannot use "-1" for performance, because some gist stuff has changed
and the restore fails. But there seems to be no option for pg_restore to
use transactions for data restore, so it's very very slow (one million
records, ea
with a separate command line option
* Use transactions everytime, and place savepoints to recover from errors?
Any ideas what I could do?
Regards
Mario
---(end of broadcast)---
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate
On 29/08/2007, Neil Conway <[EMAIL PROTECTED]> wrote:
>
> I wonder if it would be possible to keep the master version of the
> contrib docs as SGML, and generate plaintext READMEs from it during the
> documentation build.
>
Hello Neil, I think I'm doing something similar but not with README
file
_sequences better? First convert the sequences,
and reject them in the validation stage?
Regards
Mario Weilguni
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
wrong encoded sequences (so DBAs still
can turn it on if they really depend on it)?
For me,
Best regards,
Mario Weilguni
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
F8? Where
> we had to use iconv?
>
What issues? I've upgraded several 8.0 database to 8.1. without having to use
iconv. Did I miss something?
Regards,
Mario Weilguni
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
cannot be restored with pg_restore.
A dangerous feature IMO, and will make a lot of DB admins very unhappy if they
have to validate every day if the precious database dumps can be restored in
case of an error.
Best regards,
Mario Weilguni
--
Am Dienstag, 13. März 2007 14:46 schrieb Albe Laurenz:
> Mario Weilguni wrote:
> > Steps to reproduce:
> > create database testdb with encoding='UTF8';
> > \c testdb
> > create table test(x text);
> > insert into test values ('\244'); ==&g
his anyway), but I still think this is an
error, making restoration very complicated in such cases...
Or am I doing something completly wrong here?
Best regards,
Mario Weilguni
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner wi
Thanks for the info. Is there a fix for 8.1 branch, the production system is
still 8.1.
Regards
Mario Weilguni
Am Donnerstag, 15. Februar 2007 16:25 schrieb Alvaro Herrera:
> Mario Weilguni wrote:
> > Interesting: remove any of the above where conditions solves the problem
&g
same effect on both systems. Because of the large
number of tables involved it's difficult to find a self contained patch, but if
necessary I'll give it a try.
I could give 8.2.3 a try, but I doubt this will help.
Any ideas?
Regards
Mario Weilguni
---(e
Am Freitag, 12. Januar 2007 14:48 schrieb Martijn van Oosterhout:
> On Fri, Jan 12, 2007 at 11:55:07AM +0100, Mario Weilguni wrote:
> > to_char(timestamp, '') should be constant and marked immutable,
> > or am I wrong here? Or is it not marked immutable because o
amp, '') should be constant and marked immutable, or am I
wrong here? Or is it not marked immutable because of possible changes on
date_format?
Regards,
Mario Weilguni
---(end of broadcast)---
TIP 3: Have you check
; BEGIN; ...'
> would bypass the check.
Maybe not directly related to that problem, but I had a problem with "-c" last
month, when I noticed that this will not work:
psql -c "set client_encoding=iso-8859-1; select name from customer" (UTF8
database, output
On 19/12/06, Andrew Dunstan <[EMAIL PROTECTED]> wrote:
This normally a SIGQUIT, and on my machine at least the default action for
that is a core dump. Perhaps you need to say what you are trying to do and
why.
I'd like to help :-) I wanted to avoid a core dumped but you told
me that's a no
On 19/12/06, Alvaro Herrera <[EMAIL PROTECTED]> wrote:
I think the problem Mario is really trying to solve is quitting at
psql's "Password: " prompt. Ctrl-C is ignored at that point apparently.
SIGQUIT (thus Ctrl-\ in most people's setup) does it but it also dumps
c
On 20/12/06, Peter Eisentraut <[EMAIL PROTECTED]> wrote:
Mario wrote:
> When psql is running and CRTL + \ is pressed, a core dumped show up.
> In first place I ran psql into gdb, saw the backtrace and I believed
> it was a libc6 bug and I reported to my distro securi
When psql is running and CRTL + \ is pressed, a core dumped show up.
In first place I ran psql into gdb, saw the backtrace and I believed
it was a libc6 bug and I reported to my distro security team
https://launchpad.net/distros/ubuntu/+source/glibc/+bug/76437
Ubuntu edgy has got libc-2.4, a fri
still is named "foo_bar_seq".
IMO this should do:
Alter sequence foo_bar_seq rename to foo_baf_seq;
Alter table foo alter baf set default nextval('foo_baf_seq')
-Ursprüngliche Nachricht-
Von: Jonah H. Harris [mailto:[EMAIL PROTECTED]
Gesendet: Freitag, 17. No
> Uh, we did that years ago.
Really?
+ o Add ALTER TABLE RENAME COLUMN (should rename appropriate sequences and
constraints)
Sounds like this is not done, at least not renaming sequencens and constraints,
or am I wrong here?
Regard
Mario Weilguni
-Ursprüngliche Nachri
Subscribe
--
Wenn Sie glauben, dies sei ein großes Problem - warten Sie mal ab,
bis wir versuchen die Lösung zu finden. (Walter Matthau)
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/d
Yes it's hard for me, maybe because I am no native english speaker.
-Ursprüngliche Nachricht-
Von: Andrew Dunstan [mailto:[EMAIL PROTECTED]
Gesendet: Mittwoch, 18. Oktober 2006 16:11
An: Lukas Kahwe Smith
Cc: Mario Weilguni; pgsql-hackers@postgresql.org
Betreff: Re: [HACKERS] b
Nice, but I still prefer nvl. Coalesce is hard to pronounce, and even harder to
type.
-Ursprüngliche Nachricht-
Von: Andreas Joseph Krogh [mailto:[EMAIL PROTECTED]
Gesendet: Mittwoch, 18. Oktober 2006 15:48
An: pgsql-hackers@postgresql.org
Cc: Mario Weilguni
Betreff: Re: [HACKERS] bug
>
>If you want this behaviour you will have to explicitly handle it with
COALESCE().
>
>regards,
>Lukas
True. But there's a point where oracle is really better here, they named
"coalesce" "nvl" => a lot easier to type ;-)
---(end of broadcast)---
TI
Am Mittwoch, 18. Oktober 2006 13:52 schrieb Andreas Joseph Krogh:
> This has been been discussed before, but Oracle behaves differently, and
> IMHO in a more correct way.
>
> The following query returns NULL in PG:
> SELECT NULL || 'fisk';
>
> But in Oracle, it returns 'fisk':
> SELECT NULL || 'fis
What about the "char" type? Isn't it designed for that? Or will this type
disappear in future releases?
-Ursprüngliche Nachricht-
Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Im Auftrag von Heikki
Linnakangas
Gesendet: Freitag, 15. September 2006 13:35
An: Martijn van Oosterhout
Cc
This works as intended. Try this:
select coalesce(lower(firstname), '') || ' ' || coalesce(lower(lastname), '')
from person
Concating something unknown (=NULL) and a string = unknown (=NULL)
-Ursprüngliche Nachricht-
Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Im Auftrag von Andre
Hi!! I hope you are not too busy.
The thing is that i need to connect my pc which is on windows XP and the
server is on linux with postgres.
The question is?
how do I connect my windows machine to the server with postgres?
What do I have to do?, put it in steps please!!!
thanks you guys are gr
bug
fixed in CVS). Problem occurs on a 2 node cluster of 2 Quad-CPU system (Xeon, 2
physical CPU's, 2 hyperthreading), one node running the database, the other one
the webserver.
Any ideas?
Best regards,
Mario Weilguni
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
Will this patch make it into 8.2?
http://archives.postgresql.org/pgsql-patches/2004-12/msg00228.php
It's a really nice feature, would be extremly useful with tools like pgpool.
Am Freitag, 7. Juli 2006 19:13 schrieb Bruce Momjian:
> There are roughly three weeks left until the feature freeze on A
ums them (only those tuples), possibly with honouring I/O needs of
backgrounds (not steealing I/O from busy backends).
For sure not that easy as autovacuum. I'm pretty sure I've read something
about partial vacuum lately, is somebody working on something like this?
Regards,
Mario
--
easy cycle - giving developers time to fix applications. It's no good
behaviour to change something like this without any (at least time-limited )
backward compatible option.
regards
mario weilguni
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
Am Mittwoch, 10. Mai 2006 11:44 schrieb Bernd Helmle:
> --On Mittwoch, Mai 10, 2006 10:14:22 +0200 Mario Weilguni
>
> <[EMAIL PROTECTED]> wrote:
> > No, I want that there is a setting or GUC that controls whether an error
> > or a warning is raised when "begin"
Am Mittwoch, 10. Mai 2006 10:59 schrieb Peter Eisentraut:
> Am Mittwoch, 10. Mai 2006 10:10 schrieb Martijn van Oosterhout:
> > You want to make a GUC that makes:
> >
> > BEGIN;
> > BEGIN;
> >
> > Leave you with an aborted transaction? That seems like a singularly
> > useless feature...
>
> If a co
Am Mittwoch, 10. Mai 2006 09:41 schrieb Mario Weilguni:
> Am Mittwoch, 10. Mai 2006 08:19 schrieb Tom Lane:
> > Dennis Bjorklund <[EMAIL PROTECTED]> writes:
> > > Yesterday I helped a guy on irc with a locking problem, he thought
> > > that locking in postgresql
Am Mittwoch, 10. Mai 2006 08:19 schrieb Tom Lane:
> Dennis Bjorklund <[EMAIL PROTECTED]> writes:
> > Yesterday I helped a guy on irc with a locking problem, he thought
> > that locking in postgresql was broken. It turned out that he had a PHP
> > function that he called inside his transaction and t
to_timestamp is only for Oracle compatibility? I always thought it's some sort
of sql standard. What's the sql compliant way to do this?
Regards,
mario weilguni
-Ursprüngliche Nachricht-
Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Im Auftrag von Tom Lane
Gesende
Am Donnerstag, 6. April 2006 14:57 schrieb Mario Weilguni:
> mydb=# select to_timestamp(' 0300','mmdd hh24mi');
>to_timestamp
> ---
> 0001-01-01 03:00:00+01 BC
> (1 row)
>
> Questionable, but probably
Same as above.
mydb=# select to_timestamp(' 040004','mmdd hh24mi');
to_timestamp
0509-10-10 04:00:00+01
I think all except the first one should raise a warning, isn't it? Where can I
find the source code of this function?
Am Dienstag, 13. Dezember 2005 16:52 schrieb Tom Lane:
> Mario Weilguni <[EMAIL PROTECTED]> writes:
> > Since the type field is PK, there cannot be 2 rows with type='list', I
> > guess the deadlock must have some different explanation.
>
> Then the deadlo
Am Dienstag, 13. Dezember 2005 16:35 schrieb Tom Lane:
> Mario Weilguni <[EMAIL PROTECTED]> writes:
> > Version: 8.1
> > Query: update last_modified set dataend=now() where type='list'
> > DB-Error : ERROR: deadlock detected
> > DE
good idea to log the statements of both
backends (if available). Would make detecting such errors quite easier.
Best Regards,
Mario Weilguni
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subs
) applications. We using
linux bonding interface with 2 gbit NICs, and 200 MBytes/sec throughput is
something you need to have a quite some harddisks to reach that. Latency is not
bad too.
Regards,
Mario weilguni
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
Title: AW: [HACKERS] Strange left join problems in 8.1
I've tried this with cvs , -r REL8_1_STABLE (hope this was the right one), and works flawless now.
Thanks a lot!
Best regards
Mario Weilguni
-Ursprüngliche Nachricht-
Von: Tom Lane [mailto:[EMAIL PROTECTED]]
Gesende
f course I can give it a try, do I need to re-initdb when I use cvs to
checkout 8.1 tip? I don't think so, isn't it?
Best regards,
Mario Weilguni
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http:
Sort Key:
blp.mq_id
-> Seq Scan on b_ltk_protokoll blp (cost=0.00..68.16 rows=9
width=8) (actual time=0.115..1.189 rows=3
loops=1)
Filter: (grund =
''notify_verschickt_frei'::text)
-> Sort (cost=21.37..21.52 rows=60 width=17) (actual
time=0.230..0.266 rows=60
loops=1)
Sort Key:
mq.id
-> Seq Scan on abw_mailqueue mq (cost=0.00..19.60 rows=60
width=17) (actual time=0.006..0.166 rows=60 loops=1) Total runtime:
1.702 ms(15 rows)
It seems like the
planner is pulling the last where condition into the second left join,
evaluating it in wrong order.
Any idea what's
going wrong here?
Best
regards,
Mario Weilguni
Am Dienstag, 29. November 2005 10:05 schrieb Mario Weilguni:
> Hello Tom,
>
> I tried both patches on a different machine (but had to take the patches
> from cvs diff, cut'n paste from the mail-program did not work). Up until
> now, they work like a charm, correct results and
st regards,
Mario Weilguni
icomedias - Digitale Kommunikation
----
Mario Weilguni, Forschung und Entwicklung
[EMAIL PROTECTED], http://www.icomedias.com/
icomedias Österreich Systemhaus GmbH:
8020 Graz, Entenplatz 1
n the query to use IN instead of exists.
I'll compile again and try it again.
Thanks alot!
Best regards,
Mario Weilguni
-Ursprüngliche Nachricht-
Von: Tom Lane [mailto:[EMAIL PROTECTED]]
Gesendet: Mo 28.11.2005 19:39
An: Mario Weilguni
Cc: pgsql-hackers@postgresql.org
Betreff
actual time=0.008..0.009 rows=1
loops=1725)
Index Cond: (ben_id = $0)
Total runtime: 501.980 ms
Best regards
P.s. sorry for the stupid quoting, I've to use Outlook
Mario Weilguni <[EMAIL PROTECTED]> writes:
> The failing case is:
> ...
>SubPlan
> -> Hash Join
rmale
would take ~100-500 milliseconds).
I will check the patch on a different machine again and inform you of
the results.
Best regards,
Mario Weilguni
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Monday, November 28, 2005 6:09 PM
To: Mario Weilguni
Cc:
gards,
Mario Weilguni
icomedias - Digitale Kommunikation
Mario Weilguni, Forschung und Entwicklung
[EMAIL PROTECTED], http://www.icomedias.com/
icomedias Österreich Systemhaus GmbH:
8020 Graz, Entenplatz 1
Tel: +43
duces the wrong result as
well.
Best regards
Mario
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
ucture str
where bz.bid=foo1.id
and str.id = bz.str_id
and str.path ~ '*.2330676.*'
);
The path field is an "ltree" column, with an GIST index on it.
Any ideas what I could try to track this down?
Best regards,
Mar
lserver.uniqueidentifier1
> INCREMENT 1
> MINVALUE 0
> MAXVALUE 9223372036854775807
> START 0
> CACHE 1;
> GRANT ALL ON TABLE sqlserver.uniqueidentifier1 TO public;
Why do you use "GRANT ALL" and not "GRANT SELECT, UPDATE"? All means everybody
can do bad thi
hrieb Alvaro Herrera:
> Mario Weilguni wrote:
>
> Hi,
>
> > T1: BEGIN;
> > T2: BEGIN;
> > -- these are the queries similar to those from the foreign key code
> > T1: SELECT 1 FROM ONLY lookup1 x WHERE "id" = 1 FOR UPDATE OF x;
> > T2: SELECT 1 FROM ONLY
rts), but I hope the above problem might be the solution for the
insert deadylock too.
Does this sound reasonable?
Regards,
Mario Weilguni
p.s. Is it possible to modify logging so that the "SELECT 1 FROM ONLY" are
logged? Maybe this could help me finding out which queries the f
column for sorting.
Any ideas?
Regards,
Mario Weilguni
---(end of broadcast)---
TIP 6: explain analyze is your friend
d it, and on-disk I had still
"1.2.3.4.5", but the length parameter of the ltree column was 0 (sorry, I was
wrong in my first mail, on-disk was broken too.)
Might this be somehow related to the intarray bugs?
Best regards,
Mario Weilguni
p.s.: I tried hard to create a self-contained test
s: ni:75000 nu:1661 nd:216 nv:13(nf:3)
> > nt:780 All flow finish; status: 255; elapsed time: 265.48 sec
> >
> > Is this something that can be fixed for 8.0.4?
> >
> > regards, tom lane
Since 7.4 we have troubles with ltree (seldom corrupti
JFYI:
"Allow indexes to be used for MIN/MAX (Tom)
In previous releases, the only way to use index for MIN/MAX was to
rewrite the query as SELECT col FROM tab ORDER BY col LIMIT 1. This not
happens automatically."
I guess this should read "This now happens automatically"
Re
Am Freitag, 15. Juli 2005 14:19 schrieb Greg Sabino Mullane:
> > The use case is when you want to prepare a query, but only if it's not
> > already prepared on that connection.
>
> This has been covered before, but to reiterate: why would you need this?
> Any application worth its salt should be tr
In fakt, it allows users with hyphens, but you have to use quotes:
CREATE USER "foo-bar";
DROP USER "foo-bar";
Regards,
Mario Weilguni
-Ursprüngliche Nachricht-
Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Im Auftrag von Devrim GUNDUZ
Gesendet: Montag,
I've quite some trouble with the overlaps function:
SELECT overlaps('9.6.2005'::date, '9.6.2005'::date, '9.6.2005'::date,
'9.6.2005'::date);
returns true (these are german timestamps dd.mm.)
SELECT overlaps('8.6.2005'::date, '9.6.2005'::date, '9.6.2005'::date,
'9.6.2005'::date);
returns fal
Am Dienstag, 19. April 2005 09:18 schrieb Honza Pazdziora:
> Hello,
>
> the nls_string function that makes it possible to sort by arbitrary
> locale has been updated to reflect the changes in error handling in
> PostgreSQL 8.0, due to users using the nls_string sorting on 7.4 and
> requesting it fo
Dear Sir,
I' ve recently join to PostGreSql community. I'm testing it on a local
network and I'm very found of it .
However there are a few things that I'd like to understand better.
As far as i realise, every time the Server validates a wrong value for an
input it Raises an Exception with t
>
> Because their SQL queries always seem to need a target object to select
> from. i.e. "SELECT NEXTVAL.foo" isn't valid for Oracle 8/9.
>
It has been a long time since I've used Oracle, but shouldn't it be "select
foo.nextval fr
gging such problems? Even a simple dump to
stdout would be helpful.
Thanks!
Regards,
Mario Weilguni
p.s. I've checked the hardware before going online with that database, RAM is
definitly ok, and the rest of the hardware should work fine as well.
The table was vacuumed full, but vacuum
Hmmm, interesting. But I did not find 0.7 on the history page
http://www.drbd.org/releases.html
maybe it's not release status yet - thus no option for now.
Regards,
Mario Weilguni
---(end of broadcast)---
TIP 2: you can get off
info, but I've already noticed that. XFS is no option since it does not
work with drbd,
but jfs seems to be quite good.
Regards,
Mario Weilguni
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
problematic queries it produced better query plans.
Regards,
Mario Weilguni
---(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
>
> Interesting.
> We have made COMPLETELY different experiences.
>
> There is one question people ask me daily: "When can we have sychronous
> replication and PITR?".
> Performance is not a problem here. People are more interested in
> stability and "enterprise" features such as those I have
Am Tuesday 06 January 2004 21:30 schrieb Jon Jensen:
> On Tue, 6 Jan 2004, Andrew Dunstan wrote:
> > >Also, I would like to see some kind of session identifier that is more
> > >unique than pid, which wraps around. Ideally we could have 10{pid},
> > >then then the pid wraps around, 20{pid), or som
nd even those 5% are often too much, in my case it's typically below 1%.
The statistic collector could even tell the optimizer if an index scan is the
way to go...
Would that work?
Best regards,
Mario Weilguni
---(end of broadcast)--
ble MySQL 4 not tested?
That's the problem, for every performance test they choose ISAM tables, and
when transactions are mentioned it's said "MySQL has transactions". But why
no benchmarks?
Regards,
Mario Weilguni
---(end of broadcast)---
he same problem as index usage with/without quotes? However, one
would expect the same output from both queries, either the error message, or
better the 0 rows result.
Regards
Mario Weilguni
---(end of broadcast)---
TIP 3: if posting/rea
>I was playing with the Japanese win32 7.2.1 port and I noticed that "select
>0 / 0" caused the server to crash and restart. I understand that it is a
>totally unsupported version, but it should be easy enough to check vs. the
>current version. Note that select 0.0/0.0 worked fine!
Seems to work
>You can try an index like:
>create index str_idx_url on str(url) where url >= '';
>
>I think that should be identical. ('' is the smallest string, no ?)
Thanks alot, it works now. But I still think the NOT NULL case would be
useful.
B
quot;IS NULL" should be easy to recognise, since NULL is
very special. This would allow much smaller indices in some applications, for
example I've a case with a table with 20 rows where 4 values (of type
text) are not null. The index size would be much sma
ay it's not reproduceable any more. Might this notice indicate a serious
problem?
Best regards,
Mario Weilguni
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregis
scan is possible but not used:
EXPLAIN SELECT * FROM copy_of_forum_list_child WHERE f_id = 1 and
father_name = 'top';
Seq Scan on copy_of_forum_list_child (cost=0.00..2.44 rows=1width=100, costs using
index: 0.00...9.44 rows=... with=...)
Any comments?
Regards,
Mari
Am Freitag, 11. Oktober 2002 14:12 schrieb Tom Lane:
> Mario Weilguni <[EMAIL PROTECTED]> writes:
> > Is it possible to get rid of the "t_natts" fields in the tuple header?
> > Is this field only for "alter table add/drop" support?
>
> "On
hen updating/inserting
records only a compatible (a page file with the same number of attributes) page file
is used. Especially master-detail tables would
profit from this, reducing the tuple overhead by another 9%.
Might this be possible?
Regards,
Mario Weilguni
--
ports it, but I don't know about other
systems.
http://hpc.uky.edu/cgi-bin/man.cgi?section=all&topic=fgetpos64
Regards,
Mario Weilguni
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(
mm. hh24:mi:ss') into s2 from dual;
dbms_output.put_line(s1);
dbms_output.put_line(s2);
end;
/
set serverout on
execute foobar;
Hope it helps.
Regards,
Mario Weilguni
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
1 - 100 of 158 matches
Mail list logo
