usecases above?
Thanks,
Markus
--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf. | Software Development GIS
Fight against software patents in Europe! www.ffii.org
www.nosoftwarepatents.org
signature.asc
Description: OpenPGP digital signature
o the
tuplestore interface, so that the tuples are generated "on the fly" when
fetched from the tuplestore, for large resultsets?
Thanks,
Markus
--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf. | Software Development GIS
Fight against software patents i
Hi, Shane,
Shane Ambler wrote:
> CREATE TABLESPACE myramcache LOCATION MEMORY(2GB);
It's already possible to do this, just create the TABLESPACE in a
ramdisk / tmpfs or whatever is available for your OS.
HTH,
Markus
--
Markus Schaber | Logical Tracking&Tracing International
ving seen your code, I tend to assume that it's something
like a wrong length flag in some corner case in your code.
...
Markus
--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf. | Software Development GIS
Fight against software patents in Europe! ww
; the same table ?
I doubt so.
Foreign key references are among the basics of SQL, they're pretty well
tested.
Could you try to replace your image type e. G. with bytea for your test
purposes, and see, whether it crashes, too?
HTH,
Markus
--
Markus Schaber | Logical Tracking&Tracing Inter
g for a specific column value, should I, technically
> speaking, need to group by that column?
Try:
SELECT 15 as ycis_id, min(tindex), avt(tindex) from y where ycis_id = 15;
HTH,
Markus
--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf. | Software Development
ably
user defined) operators on (probably user defined) datatypes.
The parser has no real knowledge what the operators do, it simply
requests one that returns a bool.
One could make the parser to special case the = operator, and maybe some
others, however I doubt it's worth the effort.
HTH,
Markus
bug.
And that's why I talked about PostgreSQL internals.
> The original query:
> select ycis_id, min(tindex), avg(tindex) from y where ycis_id = 15;
>
> Should NOT require a "group by" to get ycis_id in the results.
And, as I wrote, this is only possible
is 'x' and c is NULL, the above statement doesn't hold
>> in PostgreSQL.
>
> Heh, well, c is supposed to be not NULL. Missed that. I was using the
> equals to include (NULL = NULL) but in SQL it's not like that.
Maybe you should replace "=" with "IS
and they are installed correctly).
Did you look at how the debian guys handle this?
HTH,
Markus
--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf. | Software Development GIS
Fight against software patents in Europe! www.ffii.org
www.nosoftwarepatents.org
signature
ation of the checkpoint record since we
> could no longer rely on the XLogRecPtr being a byte offset within the
> file.
pg_WAL_filter could "correct" the XLogRecPtr and file sizes during the
filter run.
HTH,
Markus
--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl.
tay neutral, but point the user to possible
solutions of his problem.
HTH,
Markus
--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf. | Software Development GIS
Fight against software patents in Europe! www.ffii.org
www.nosoftwarepatents.org
signature.asc
Description: OpenPGP digital signature
at the block boundary case could be tested. Is
> there any precedent on where to grab such a large chunk of data from?
You could generate such data on the fly, as part of the test scripts.
E. G. a blob of zero bytes, blob of 0xff bytes, a blob of pseudo random
data...
Markus
--
Markus Sc
d and larger (int, double)
fields.
Markus
--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf. | Software Development GIS
Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org
signature.asc
Description: OpenPGP digital signature
Hi, Gevik,
Gevik Babakhani wrote:
> typreceive = not supported
> typsend = not supported
Any reason why you don't want to support binary transmissions?
Thanks,
Markus
--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf. | Software Development GIS
ll the "other stuff" such as functions really needs to be in the
> first part ... or at least there's no visible benefit to delaying
> loading it.
I agree, it has to be in the first part, especially as data types and
input functions needed for the table definitions and table dat
just have a snapshot which is reverted after each run, and read-only
> access to files used to do the build. I know vmware supports this,
> probably others too...
A chroot / fakeroot combined with unionfs should do the same, probably
with less effort. There are other user-mode jail projects that
vely.
It should have statistics about TOAST data, and then see whether he'd
need to detoast for condition checking and for actual data fetching.
Thanks,
Markus
--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf. | Software Development GIS
Fight against software
it outside a transaction block
> then the ANALYZE is divided into multiple xacts and so doesn't try to
> hold locks on multiple tables concurrently. autovacuum won't try to do
> that either.)
Is there any reason to allow ANALYZE run insinde a transaction at all?
Markus
--
Ma
ad query plans for later commands in the transaction.
OK, I see.
But this leads to the danger that, should the transaction abort
afterwards, we're left with borked stats, or are those rolled back
accordingly?
Markus
--
Markus Schaber | Logical Tracking&Tracing International A
CE] [PUBLIC|PRIVATE] FUNCTION ..."
seems the "most sexy" variant in my eyes.
HTH,
Markus
--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf. | Software Development GIS
Fight against software patents in Europe! www.ffii.org
www.nosoftwarepatents.org
signature.asc
Description: OpenPGP digital signature
.
The only possible bug I could see is that your mailer implements the
indentation incorrectly (tabs vs. spaces, incorrect level of indentation
etc.).
Markus
--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf. | Software Development GIS
Fight against software patents
Hi, Bruce,
Markus Schaber wrote:
>> Should I try hacking my mail reader to prevent this? I think I see
>> where it is happening in the code.
>
> AFAICT, the wrapping of long header lines by indentation (as your mailer
> seems to do) is RFC conformant, so I think it is ma
n CVS from the wiki, that
> should help].
Maybe you should rename the public writable Wiki page list to Wishlist
instead of Todo, to make the difference more explicit.
Thanks,
Markus
--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf. | Software Development GIS
F
charge of cards was
manufactured this way. Officially, it was a bug in the eeprom content
generating software, but there were rumours that the manufacturer wanted
to avoid paying the registration fees for the mac address ranges...
Just gettin' off topic,
Markus
--
Markus Schaber | Logical T
. 7.4.0 to 7.4.13). So, if it's not in the release
notes, it is unlikely that it dit make it into the 7.4 releases.
You may try backporting it yourself, or use a cronjob or such issuing
regular REINDEX commands during the night (or whenever you have idle hours).
HTH;
Markus
--
Markus Scha
vacuum should just throw a WARNING when it
> finds a single rel with more than MaxFSMPages pages with useful free space?
+1 for both from my side, it has bitten me and our admins several times now.
Thanks,
Markus
--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. I
, the change is listed on
http://www.postgresql.org/docs/7.4/interactive/release-7-4.html
So, as it _is_ in the release notes, this does not render my statement
wrong, but pointless :-)
Thanks for your correction,
Markus
--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. I
Hi, Luke,
Luke Lonergan wrote:
> If it's going to roll back the entire load after that one warning, it
> should terminate there.
AFAIK, a warning is no reason for PostgreSQL to roll back anything.
That's the difference between a warning and an error.
HTH,
Markus
--
Markus S
Hi, Hannu,
Hannu Krosing wrote:
> Are you sure it's UCS-4 ? I've always thought that XML is what is given
> in tag, and utf-8 if no charset is given.
You have to distinguish between the supported charset, and the document
encoding.
HTH,
Markus
--
Markus Schaber | Logical
t using LATIN-1 as encoding, the charset still is
Unicode, giving us the possibility to use &entities; to use non-latin1
characters.
HTH,
Markus
--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf. | Software Development GIS
Fight against software pat
ed UTF8 encoding for this. It's also possible using ASCII
encoding + ቧ entities.
But we need the Charset to be Unicode.
HTH,
Markus
--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf. | Software Development GIS
Fight against software patents in Europe! www.ffii.org
www.nosoftwarepatents.org
signature.asc
Description: OpenPGP digital signature
rt to make it work in 8.3.
Thanks,
Markus
--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf. | Software Development GIS
Fight against software patents in Europe! www.ffii.org
www.nosoftwarepatents.org
signature.asc
Description: OpenPGP digital signature
dump.html
seem not to mention this option.
HTH,
Markus
--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf. | Software Development GIS
Fight against software patents in Europe! www.ffii.org
www.nosoftwarepatents.org
signature.asc
Description: OpenPGP digital signature
e that the same behaviour could be achieved with triggers, but
with much higher overhead for non-regular tasks.
Thanks,
Markus
--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf. | Software Development GIS
Fight against software patents in Europe! www.ffii.org
www.nosoftwarepatents.org
signature.asc
Description: OpenPGP digital signature
e-wise and will so fail to delete properly multi-byte
> characters. I have no idea if this is a problem of psql or some other
> problem, and it was not annoying enough to report it...
I think this could be a problem with libreadline / libedit not being
utf8-safe.
HTH,
Markus
--
Markus Sc
Hi, Bruce,
Bruce Momjian wrote:
>
>
> Allow inheritance to be removed from tables
>
>
I'd enhance that to "Allow table inheritance relationships to be defined
for and removed from pre-existing tables."
HTH,
Markus
--
Mar
Allow table inheritance to be added and removed from
> pre-existing tables
Agree, that's excellent.
Thanks,
Markus
--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf. | Software Development GIS
Fight against software patents in Eur
Hi, Marlon,
Marlon Petry wrote:
> would like to know postgres implements ACID ?
>
> has some document ?
http://www.postgresql.org/docs/8.1/interactive/transaction-iso.html
HTH,
Schabi
--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf. | Software De
the
EJB3 code, it was part of the archive file when I unpacked, and I forgot
to ignore it when checking in.
It's removed now, together with a clarification in the README.
HTH,
Markus
--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf. | Software Development GIS
Hi,
Markus Schaber wrote:
[something about a postgis.jar]
Please ignore that mail, it got to the wrong list.
Thanks,
Markus
--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf. | Software Development GIS
Fight against software patents in Europe! www.ffii
is ungood from a security point of
> view.
There's another disadvantage of always copying 64 bytes:
It may be that the 64-byte range crosses a page boundary. Now guess what
happens when this next page is not mapped -> segfault.
Markus
--
Markus Schaber | Logical Tracking&Tra
propriate port gets a dump of the
database. :-)
HTH,
Markus
--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf. | Software Development GIS
Fight against software patents in Europe! www.ffii.org
www.nosoftwarepatents.org
signature.asc
Description: OpenPGP digital signature
)/receive() are only used for client
communication in the V3 protocol binary mode, and COPY in binary mode,
but the backend stores them in the tables as_is (modulo compression/
TOASTing).
Is my assumption correct?
Btw, I'm going to triple-check this in the source and via tests, too.
Thank
Hi, Martijn,
Martijn van Oosterhout wrote:
> It would be terribly inefficient to call those functions for each
> read/write. The disk has the internal format, send/receive deal with a
> portable not-host-dependant representation of the data.
Thanks.
Markus
--
Markus Schaber
-)
>
> Oh, man, my head just exploded reading that. That's taking evil and
> being *creative* with it. :)
Well, combine that with some firewall / hosts.allow rules, and sslwrap
with certificate based 2-way authentication, if you "insist" on
security. :-)
Keep on lauging,
Hi,
I'm happy that the rather verbose "timestamp with time zone" has the
much nicer alias "timestamptz", however it seems that this alias is not
documented, neither at
http://developer.postgresql.org/pgdocs/postgres/datatype-datetime.html
nor at http://www.postgresql.org/docs/8.1/interactive/datat
ble. But there are no
+ plans to drop the short aliases in future versions.
+
+
+
time, timestamp, and
interval accept an optional precision value
HTH,
Markus
--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf. | Software Development GIS
Fight ag
d in the table on the datatype TOC page), it's also
about telling the user which of the names are the ones to avoid, and the
reasons to do so.
HTH,
Markus
--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf. | Software Development GIS
Fight against
have more than one tsearch expression in the
query (e. G. by joining different tables), so that will help further.
HTH,
Markus
--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf. | Software Development GIS
Fight against software patents in Europe! www.ffii.org
least compatibility with the SQL standard, as well as with other
Databases might be a reason.
Using pure "timestamp" may lead human readers to be confused, because it
has both meanings with and without timezone historically, this might be
a reason to prefer the "timestamp with[ou
ly awful idea, not least because it
> would make it impossible to have stable regression-test outputs.
>
> I'm not really convinced that we need more than the function name.
I also think that the OID will hurt here, but schema and argument types
may be useful in some corner case
switches appeared. Is that OK?
Sounds fine.
Is there a possibility to dump only those objects? Maybe --large-objects
and --languages?
Thanks,
Markus
--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf. | Software Development GIS
Fight against software paten
le mv bkdir pgdir, gets
> you started again.
But when people have enough bandwith and disk space to copy the pg
directory, they also have enough to create and store a bzip2 compressed
dump of the database.
Or did I miss something?
HTH,
Markus
--
Markus Schaber | Logical Tracking&Tracing In
GIS for examples of how to use GIST.
HTH,
Markus
--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf. | Software Development GIS
Fight against software patents in Europe! www.ffii.org
www.nosoftwarepatents.org
signature.asc
Description: OpenPGP digital signature
nction costs (concatenation,
GeomUnion etc.) can be estimated via the average field size of the tables.
Has that idea been considered?
HTH,
Markus
--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf. | Software Development GIS
Fight against software patents in Europe! www
Hi, Tom,
Tom Lane schrieb:
> Anyway the short-term answer for Markus is "don't do it that way".
> We ought to think about making the backend's behavior more consistent,
> though.
I'll split the query into three. Having it in one query just was a
convenience here.
Thanks,
Markus
---
Hi, Josh,
Josh Berkus wrote:
> Yes, actually. We need 3 different estimation methods:
> 1 for tables where we can sample a large % of pages (say, >= 0.1)
> 1 for tables where we sample a small % of pages but are "easily estimated"
> 1 for tables which are not easily estimated by we can't afford
you give us some pointers (names, URLs,
papers) to such algorithms?
Thanks a lot,
Markus
--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf. | Software Development GIS
Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org
--
Hi, Mark,
Mark Lewis schrieb:
> It seems that instead of maintaining a different sorting code path for
> each data type, you could get away with one generic path and one
> (hopefully faster) path if you allowed data types to optionally support
> a 'sortKey' interface by providing a function f whi
Hi, David,
David Lang schrieb:
>> In SQL_ASCII, just take the first 4 characters (or 8, if using a 64-bit
>> sortKey as elsewhere suggested). The sorting key doesn't need to be a
>> one-to-one mapping.
> that would violate your second contraint ( f(a)==f(b) iff (a==b) )
no, it doesn't.
When b
Hi, Ron,
Ron schrieb:
> OK, so here's _a_ way (there are others) to obtain a mapping such that
> if a < b then f(a) < f (b) and
> if a == b then f(a) == f(b)
>
> Pretend each row is a integer of row size (so a 2KB row becomes a 16Kb
> integer; a 4KB row becomes a 32Kb integer; etc)
> Since eve
Hi, Ron,
Ron Peacetree wrote:
> Where "*" ==
> {print | save to PDF | save to format | display on screen}
>
> Anyone know of one?
psql with fancy output formatting comes to my mind, or "COPY table TO
file" SQL command.
HTH,
Markus
--
Markus Schaber | Logica
Hi, Andrew,
Andrew Dunstan wrote:
> How on earth can either of these have to do with producing an ERD?
Sorry, the ERD thing got lost in my mind while resolving the "*".
Markus
--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf. | Software Devel
day'
can be '1 month 27 days', '1 month 28 days', '1 month 29 days' or '1
month 30 days', depending on the timestamp we apply the interval.
Markus
--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf. | Software Development GIS
e estimator
functions have an implicit return parameter of int8. Parameters may be
NULL when they are not known at query planning time.
What do you think about this idea?
The same scheme could be used to add a CPUCOST_ESTIMATOR to expensive
functions.
HTH,
Markus
--
Markus Schaber | Logical Track
E. G. for generate_series we return ($2-$1)/$3, and for some functions
even constant estimates will be good enough.
> - please execute me and store my results in a temporary storage,
> count the rows returned, and plan the outer query accordingly
That's an interesting idea.
aps a better solution would be to cache the
> result of the estimator function.
Sophisticated estimator functions are free to use the pg_statistics
views for their row count estimation.
HTH,
Markus
--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf. | Software Dev
on, but the procedure could add
additional rows to it.
Markus
--
markus schaber | dipl. informatiker
logi-track ag | rennweg 14-16 | ch 8001 zürich
phone +41-43-888 62 52 | fax +41-43-888 62 53
mailto:[EMAIL PROTECTED] | www.logi-track.com
signature.asc
Description: OpenPGP digital signature
ration could be like
"returns (touchedrows int, somethingelse datetime), setof (article int,
description text)" for a function/method that has two resultsets, one of
those with always one row.
markus
--
markus schaber | dipl. informatiker
logi-track ag | rennweg 14-16 | ch 8001 zürich
ph
70 matches
Mail list logo