On 1/8/08, Tom Lane <[EMAIL PROTECTED]> wrote:
> The other issue that ought to be on the TODO radar is that we've only
> plugged the hole for the very limited case of maintenance operations that
> are likely to be executed by superusers. If user A modifies user B's
> table (via INSERT/UPDATE/DELE
On 1/1/08, kenneth d'souza <[EMAIL PROTECTED]> wrote:
> I am trying to understand concurrency and mvcc with a small example in
> psql.
Note that the big advantage to MVCC is that writers do not block
readers. Since your example consists of all writers, MVCC isn't doing
much for you.
> Isolation
On 12/28/07, Tom Lane <[EMAIL PROTECTED]> wrote:
> "Trevor Talbot" <[EMAIL PROTECTED]> writes:
> > There's a fundamental problem that you can't make someone else do
> > authentication if they don't want to, and that's exactly the situation
On 12/28/07, Andrew Sullivan <[EMAIL PROTECTED]> wrote:
> On Sat, Dec 29, 2007 at 02:09:23AM +1100, Naz Gassiep wrote:
> > In the web world, it is the client's responsibility to ensure that they
> > check the SSL cert and don't do their banking at
> > www.bankofamerica.hax0r.ru and there is nothin
On 12/23/07, Tomasz Ostrowski <[EMAIL PROTECTED]> wrote:
> On Sun, 23 Dec 2007, Magnus Hagander wrote:
> > I'm just surprised that people are actually surprised by this. To me,
> > it's just a natural fact that happens to pretty much all systems. And a
> > good reason not to let arbitrary users ru
On 12/20/07, Magnus Hagander <[EMAIL PROTECTED]> wrote:
> On Thu, Dec 20, 2007 at 04:39:55AM -0800, Trevor Talbot wrote:
> > On 12/20/07, Magnus Hagander <[EMAIL PROTECTED]> wrote:
> > > ereport(WARNING,
> > > (errmsg("could n
On 12/20/07, Magnus Hagander <[EMAIL PROTECTED]> wrote:
> On Thu, Dec 20, 2007 at 04:39:55AM -0800, Trevor Talbot wrote:
> > On 12/20/07, Magnus Hagander <[EMAIL PROTECTED]> wrote:
> > > ereport(WARNING,
> > > (errmsg("could n
On 12/20/07, Magnus Hagander <[EMAIL PROTECTED]> wrote:
> ereport(WARNING,
> (errmsg("could not open file \"%s\": %s violation", fileName,
> (GetLastError() ==
> ERROR_SHARING_VIOLATION)?_("sharing"):_("lock")),
> errdetail("Continuing to retry for 30 seconds."),
>
On 12/17/07, Decibel! <[EMAIL PROTECTED]> wrote:
> Also, has anyone looked into adding a class of system calls that
> would actually tell us if the kernel issued physical IO? I find it
> hard to believe that other RDBMSes wouldn't like to have that info...
Non-blocking style interfaces can help h
On 12/11/07, Tom Lane <[EMAIL PROTECTED]> wrote:
> Alvaro Herrera <[EMAIL PROTECTED]> writes:
> I dunno anything about how to fix the real problem (what's winsock error
> 10004?), but I don't think he'd be seeing full speed log filling in
> 8.2.5.
WSAEINTR, "A blocking operation was interrupted b
On 12/11/07, Simon Riggs <[EMAIL PROTECTED]> wrote:
> Compressed Tablespaces
> Using a streaming library like zlib, it will be easy to read/write data
> files into a still-usable form but with much reduced size. Access to a
> compressed table only makes sense as a SeqScan. That would be handled b
On 12/7/07, Dave Page <[EMAIL PROTECTED]> wrote:
> Tom Lane wrote:
> > AFAIK, time_t is a Unix-ism, so it's pretty unlikely to be used in the
> > APIs of anything on Windows.
> Oh, it is.
It's confined to the C Runtime libraries, not part of the Windows API
proper. (Three exceptions: IP Helper u
On 11/28/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> Yes, you support (and worry about) encodings simply because of a C limitation
> dating from 1974, if I recall correctly...
> In Java, for example, a "char" is a very well defined datum, namely a Unicode
> point. While in C it can be some
On 11/28/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> On Wednesday 28 November 2007, Trevor Talbot wrote:
> > I'm not entirely sure how that's supposed to solve the client
> > authentication issue though. Demanding that clients present auth data
> > in
On 11/28/07, Martijn van Oosterhout <[EMAIL PROTECTED]> wrote:
> On Wed, Nov 28, 2007 at 05:54:05PM +0200, [EMAIL PROTECTED] wrote:
> > Regarding the problem of "One True Encoding", the answer seems obvious to
> > me:
> > use only one encoding per database cluster, either UTF-8 or UTF-16 or
> >
On 11/15/07, Peter Eisentraut <[EMAIL PROTECTED]> wrote:
> In practice, the search pattern will mostly be provided dynamically from some
> user input, so you could conceivably be able to modify the search patterns
> more readily than the entire queries in your application. Anyway, it's just
> an
On 11/14/07, Peter Eisentraut <[EMAIL PROTECTED]> wrote:
> I wrote:
> > What we'd need is a way to convert a LIKE pattern into a tsquery
> > ('%foo%bar%' => 'foo & bar'). Then you might even be able to sneak
> > index-optimized text search into existing applications. Might be worth a
> > try.
>
>
On 11/14/07, Tom Lane <[EMAIL PROTECTED]> wrote:
> The other problem with using modulo is that it makes the result depend
> mostly on the low-order bits of the random() result, rather than mostly
> on the high-order bits; with lower-grade implementations of random(),
> the lower bits are materiall
On 11/13/07, Peter Eisentraut <[EMAIL PROTECTED]> wrote:
> Am Dienstag, 13. November 2007 schrieb Gregory Stark:
> > "Peter Eisentraut" <[EMAIL PROTECTED]> writes:
> > > What we'd need is a way to convert a LIKE pattern into a tsquery
> > > ('%foo%bar%' => 'foo & bar'). Then you might even be abl
On 11/12/07, Magnus Hagander <[EMAIL PROTECTED]> wrote:
> On Mon, Nov 12, 2007 at 04:00:04AM -0800, Trevor Talbot wrote:
> > On 11/12/07, Magnus Hagander <[EMAIL PROTECTED]> wrote:
> > > On Sat, Nov 10, 2007 at 03:17:13PM -0800, Trevor Talbot wrote:
> >
>
On 11/12/07, Richard Huxton <[EMAIL PROTECTED]> wrote:
> Gokulakannan Somasundaram wrote:
> >>> I also noticed that it doesn't crash with psql, but it takes a
> >>> long time to show the first set of records. It takes a long time, even
> >>> to quit after i pressed 'q'.
> >>>With oracle SQ
On 11/12/07, Magnus Hagander <[EMAIL PROTECTED]> wrote:
> On Sat, Nov 10, 2007 at 03:17:13PM -0800, Trevor Talbot wrote:
> > As for desktop heap, only 65KB of the service heap was allocated, or
> > about 80 bytes per connection. No danger of hitting limits in the
> >
I've seen several comments about shared memory under Windows being
"slow", but I haven't had much luck finding info in the archives.
What are the details of this? How was it determined and is there a
straightforward test/benchmark?
---(end of broadcast)---
On 10/26/07, I wrote:
> On 10/26/07, Magnus Hagander <[EMAIL PROTECTED]> wrote:
>
> > Can you try the attached patch? See how many backends you can get up to.
> >
> > This patch changes from using a single thread for each backend started to
> > using the builtin threadpool functionality. It also re
On 11/8/07, Magnus Hagander <[EMAIL PROTECTED]> wrote:
> Andrew Dunstan wrote:
> > Tom Lane wrote:
> >> Are Windows users accustomed to having up-to-the-minute timezone
> >> information? Maybe there's something I don't know about Microsoft's
> >> update practices, but I would have thought that t
On 10/26/07, Magnus Hagander <[EMAIL PROTECTED]> wrote:
> Can you try the attached patch? See how many backends you can get up to.
>
> This patch changes from using a single thread for each backend started to
> using the builtin threadpool functionality. It also replaces the pid/handle
> arrays wi
On 10/22/07, Tom Lane <[EMAIL PROTECTED]> wrote:
> Magnus Hagander <[EMAIL PROTECTED]> writes:
> > I was planning to make it even easier and let Windows do the job for us,
> > just using RegisterWaitForSingleObject(). Does the same - one thread per
> > 64 backends, but we don't have to deal with th
On 10/22/07, Magnus Hagander <[EMAIL PROTECTED]> wrote:
> Trevor Talbot wrote:
> > I'd probably take the approach of combining win32_waitpid() and
> > threads. You'd end up with 1 thread per 64 backends; when something
> > interesting happens the thread co
On 10/21/07, Magnus Hagander <[EMAIL PROTECTED]> wrote:
> > I tried generating idle connections in an effort to reproduce
> > Laurent's problem, but I ran into a local limit instead: for each
> > backend, postmaster creates a thread and burns 4MB of its 2GB address
> > space. It fails around 490.
On 10/14/07, Gokulakannan Somasundaram <[EMAIL PROTECTED]> wrote:
> http://www.databasecolumn.com/2007/09/one-size-fits-all.html
> > > The Vertica database(Monet is a open source version with the same
> > > principle) makes use of the very same principle. Use more disk space,
> > > since they are
On 10/12/07, Dave Page <[EMAIL PROTECTED]> wrote:
> Tom Lane wrote
> > That still leaves us with the problem of how to tell whether a locale
> > spec is bad on Windows. Judging by your example, Windows checks whether
> > the code page is present but not whether it is sane for the base locale.
> >
On 10/11/07, Tom Lane <[EMAIL PROTECTED]> wrote:
> "Trevor Talbot" <[EMAIL PROTECTED]> writes:
> > Neither is the birth certificate. The recorded, legal time of the
> > birth is the one that was written down. If it doesn't happen to match
> >
On 10/11/07, Gregory Stark <[EMAIL PROTECTED]> wrote:
> "Trevor Talbot" <[EMAIL PROTECTED]> writes:
> > While I agree that UTC storage is definitely a needed option, I was
> > trying to point out in the scenario above that sometimes an event
> > recor
On 10/11/07, Gregory Stark <[EMAIL PROTECTED]> wrote:
> "Tom Lane" <[EMAIL PROTECTED]> writes:
>
> > "Trevor Talbot" <[EMAIL PROTECTED]> writes:
> >> On 10/11/07, Magne Mæhre <[EMAIL PROTECTED]> wrote:
> >>> Trevor Tal
On 10/11/07, Magne Mæhre <[EMAIL PROTECTED]> wrote:
> Trevor Talbot wrote:
> > Thinking that it might have had out of date zone rules brings up an
> > interesting scenario though. Consider a closed (no networking or
> > global interest) filing system in a local o
On 10/10/07, Tom Lane <[EMAIL PROTECTED]> wrote:
> "Trevor Talbot" <[EMAIL PROTECTED]> writes:
> > Actually, what I meant at least (not sure if others meant it), is
> > storing the value in the timezone it was entered, along with what zone
> > that was.
On 10/10/07, Tom Lane <[EMAIL PROTECTED]> wrote:
> The arguments that have been made for storing a zone along with the UTC
> value seem to mostly boil down to "it should present the value the same
> way I entered it", but if you accept that argument then why do we have
> DateStyle? If it's OK to
On 10/9/07, Peter Eisentraut <[EMAIL PROTECTED]> wrote:
> Independent of what any specification might say, however, the currently
> implemented behavior is clearly wrong in my mind and needs to be fixed.
I don't think it's wrong, just a particular choice. As an example,
consider an interval sche
I wrote:
> On 10/8/07, Bruce Momjian <[EMAIL PROTECTED]> wrote:
> > I had a thought a week ago. If we update the time zone database for
> > future dates, and you have a future date/time stored, doesn't the time
> > change when the time zone database changes.
> >
> > For example if I schedule an ap
On 10/8/07, Bruce Momjian <[EMAIL PROTECTED]> wrote:
> I had a thought a week ago. If we update the time zone database for
> future dates, and you have a future date/time stored, doesn't the time
> change when the time zone database changes.
>
> For example if I schedule an appointment in New Zeal
Note that unless there's some tools issue, DllMain doesn't need to be
exported to function properly. A DLL's initialization routine is
marked as the entry point in the PE header, same as main() in classic
C.
It might be simpler to just get rid of the export.
---(end of br
While reading one of the recent -perform threads, it occurred to me to
check, and the 8.2.4 Win32 release binaries aren't marked "large
address aware". This means the process gets a 2GB VM space, which is
normal for 32bit Windows. On x64, my understanding is that each 32
bit process can actually
On 9/6/07, apoc9009 <[EMAIL PROTECTED]> wrote:
> Backup 12/24/2008 Version 2
> /pg/backup/12_24_2008/base/rcvry.rcv <--- Basebackup
> /pg/backup/12_24_2008/changes/0001.chg <--- Changed Data
> /changes/0002.chg <--- Changed Data
>
On 9/3/07, Mark Mielke <[EMAIL PROTECTED]> wrote:
> Tom Lane wrote:
> > Also, says that Windows throws an error for ":" in the filename,
> > which means we needn't.
> Windows doesn't fail - but it can do odd things. For example, try:
>
> C:\> echo hi >foo:bar
>
> If one then checks the di
On 9/2/07, Gregory Stark <[EMAIL PROTECTED]> wrote:
> Right, traditionally the only characters forbidden in filenames in Unix are /
> and nul. If we want the files to play nice in Gnome etc then we should
> restrict them to ascii since we don't know what encoding the gui expects.
>
> Actually I th
On 8/27/07, Jonah H. Harris <[EMAIL PROTECTED]> wrote:
> On 8/27/07, Tom Lane <[EMAIL PROTECTED]> wrote:
> > that and the lack of evidence that they'd actually gain anything
>
> I find it somewhat ironic that PostgreSQL strives to be fairly
> non-corruptable, yet has no way to detect a corrupted pa
On 8/18/07, Tom Lane <[EMAIL PROTECTED]> wrote:
> As my copy of the patch currently stands, there are two built-in trigger
> functions, tsvector_update_trigger and tsvector_update_trigger_column.
> The first expects trigger arguments
> name of tsvector col, name of tsconfig to use, name(s) of
On 8/18/07, Bruce Momjian <[EMAIL PROTECTED]> wrote:
> Trevor Talbot wrote:
> > Well, you could create a function that returns a tsvector, but how do
> > you get that to work with queries? I've been under the impression the
> > expressions need to match (in the n
On 8/18/07, Bruce Momjian <[EMAIL PROTECTED]> wrote:
> Remember an expression index can be a user-created function so you can
> embed whatever you want in your function and just index it's output,
> just like you would with a trigger creating a separate column.
Well, you could create a function t
Digging through the simple vs advanced user discussion, I don't think
expression indexes are really the right idea. It seems a bit fragile,
you need a certain amount of knowledge about the optimizer to figure
out if your queries can even use the index, and it's just plain ugly.
It also seems like
On 8/17/07, Tom Lane <[EMAIL PROTECTED]> wrote:
> At the moment I feel our thoughts have to revolve not around adding
> complexity to tsearch, but taking stuff out. If we ship it with no
> schema support for TS objects in 8.3, we can always add that later,
> if there proves to be real demand for
Tom Lane <[EMAIL PROTECTED]> wrote:
> Gregory Stark <[EMAIL PROTECTED]> writes:
> > "Tom Lane" <[EMAIL PROTECTED]> writes:
> >> Uh, no. Function names for example are subject to search-path
> >> confusion.
>
> > Wait, are they? They are in PL languages but only because most
> > languages store the
On 8/16/07, Tom Lane <[EMAIL PROTECTED]> wrote:
> Actually ... I'm suddenly not happy about the choice to put text search
> configurations etc. into schemas at all. We've been sitting here and
> assuming that to_tsvector('english', my_text_col) has a well defined
> meaning --- but as the patch st
53 matches
Mail list logo