w if there are any questions. -sc
--
Sean Chittenden
se...@joyent.com
ism.patch
Description: Binary data
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
w if there are any questions. -sc
--
Sean Chittenden
se...@joyent.com
GUC as suggested. What's your take on the
attached patch?
-sc
--
Sean Chittenden
se...@joyent.com
On Oct 4, 2017, 10:56 AM -0700, Andres Freund , wrote:
> Hi,
>
> On 2017-10-04 10:47:06 -0700, Sean Chittenden wrote:
> > Hello. We identified the same problem. Sam Gwydir
/kib/pgsql_perf.pdf
[2]
http://www.freebsd.org/cgi/man.cgi?query=mmap&apropos=0&sektion=0&manpath=FreeBSD+10.0-stable&arch=default&format=html
[3]
http://www.freebsd.org/cgi/man.cgi?query=madvise&sektion=2&apropos=0&manpath=FreeBSD+10.0-stable
--
Sean Chittende
so I thought
I’d prod and ask. Thanks in advance. -sc
--
Sean Chittenden
s...@chittenden.org
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
).
I made a cursory pass over the code and found one other instance where write
status wasn’t being checked and also included that.
-sc
pg_dump_check_write.patch
Description: Binary data
--
Sean Chittenden
s...@chittenden.org
--
Sent via pgsql-hackers mailing list (pgsql-hackers
tly what the
problem was. Attached is an improved error message:
> "ERROR: XX000: no schemas in search_path are available for CREATE EXTENSION"
-sc
src-backend-commands-extension.c.patch
Description: Binary data
--
Sean Chittenden
s...@chittenden.org
--
Sent via pgsql-hackers ma
at one.
Sounds good to me and is clear enough that it would unblock me w/o having to
resort to the source tree. -sc
--
Sean Chittenden
s...@chittenden.org
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
w releases... and while we're at it, can we prefer PFS ciphers?
> I have still to find where the actual problems are happening in
> unreliable networks ...
I'm guessing you're blocking on /dev/random on some systems and that's
the source of unreliability/timeouts.
> [1] c
oned above re: breaking out of the loop, there
should probably be a ssl_renegotiation_min tunable so that the client
can't renegotiate too fast.
The default ssl_ciphers in the examples should also be updated as well
(e.g. we still allow SSLv2):
ssl_ciphers =
'ECDHE-RSA-AES128-SHA256:AES128-GC
54:53.854165855 +0300
> +++ src/template/freebsd2014-05-26 23:55:12.307880900 +0300
> @@ -3,3 +3,4 @@
> case $host_cpu in
>alpha*) CFLAGS="-O";; # alpha has problems with -O2
> esac
> +USE_NAMED_POSIX_SEMAPHORES=1
-sc
--
Sean Chittenden
s...@chittenden
direction before.
>
> If you meant to propose using *unnamed* POSIX semaphores, that might be
> a reasonable change, but it would still need some supporting evidence.
https://lists.freebsd.org/pipermail/svn-src-stable-10/2014-October/003515.html
-sc
--
Sean Chittenden
s...@chittende
ll be set to "english".
>
> initdb: directory "/tmp/pginit-test" exists but is not empty
> If you want to create a new database system, either remove or empty
> the directory "/tmp/pginit-test" or run initdb
> with an argument other than "/tmp/pgi
re of any special directories exposed by
>> filesystems that aren't dot directories so this seems like a relatively
>> futureproof solution, too.
> lost+found
It's been a long time since I've seen that directory. Patch updated. -sc
--
Sean Chittenden
s...@chittenden.org
recommending that a cluster not be created at
> a mount point; it should be created in a directory underneath the
> mount point.
Giving filesystem advice is a large topic that I'm sure is covered someplace in
the handbook. A general warning isn't a bad idea, however. *
up a test methodology. Using INT8 internally was too
convenient at the time.
--
Sean Chittenden
s...@chittenden.org
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
ts, measuring the output, and then sending the user the
results in the form of recommended values would be huge.
Where could I look for an explanation of all of these
values?
-sc
--
Sean Chittenden
---(end of broadcast)---
TIP 6: Have you
istrators.
Username: john.doe
Database: foo.com
possible pg_shadow entry #1: john.doe.foo.com
possible pg_shadow entry #2: [EMAIL PROTECTED]
If people are worried about the sorting, ORDER BY domain, username.
My $0.02. -sc
--
Sean Chittenden
---(end of broadcast)---
as and whatnot, but isn't a user going to be in their own
schema to begin with? As for the order by, I've got a list of users
per "account" (sales account), so doing the order by is on two columns
and the pg_shadow table is generated periodically from our inhouse
tables. -sc
--
Sean Chittenden
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
tly. If
those functions existed, then I think everyone would be able to have
their pie as they want it. -sc
--
Sean Chittenden
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
ewhere','@'),
> split_after('me@somewhere','@');
> split_before | split_after
> --+-
> me | somewhere
> (1 row)
Oh that was handy and fast! I didn't know of strpos(). Cool, who
says 'ya can't le
c/product/rtrmgmt/chse/1105/1_3/install/appl_cli.htm
(search for PostgreSQL)
-sc
--
Sean Chittenden
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
in/pg_dump'
gmake[2]: *** [all] Error 2
gmake[2]: Leaving directory `/usr/home/sean/open_source/postgresql/pgsql/src/bin'
gmake[1]: *** [all] Error 2
gmake[1]: Leaving directory `/usr/home/sean/open_source/postgresql/pgsql/src'
gmake: *** [all] Error 2
*** Error
clude -c -o common.o common.c
> In file included from common.c:21:
> pg_backup_archiver.h:168: syntax error before "off_t"
> gmake[3]: *** [common.o] Error 1
--
Sean Chittenden
Index: pg_backup_archiver.h
===
ypes -Wmissing-declarations
>-I../../../src/interfaces/libpq -I../../../src/include -c -o common.o common.c
> > In file included from common.c:21:
> > pg_backup_archiver.h:168: syntax error before "off_t"
> > gmake[3]: *** [common.o] Error 1
'nothe
each of the CLI tools. Anyone have any thoughts on the best way to
solve this? -sc
--
Sean Chittenden
msg21435/pgp0.pgp
Description: PGP signature
asn't. See
my next message for details.
-sc
--
Sean Chittenden
msg21991/pgp0.pgp
Description: PGP signature
have flex required for the
build dependencies and setting -Cf or -CF for building the scanner
(need to check the archives for which turned out to be faster).
I'm also tinkering with the idea of automatically turn off fsync if
optimize is set. Objections? -sc
--
Sean Chittenden
msg21992/pgp0.pgp
Description: PGP signature
ue
> from whether you trust your disk hardware, power source, etc.
> Puh-leez do not muddy the waters by introducing a port-specific
> variation in choices that only the DBA of a particular installation
> should make.
Whoop, guess I won't do that. :~) Thanks. -sc
--
Sean Chittenden
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
e!!! I've got a few systems running GCC 3.2 and
3.3 and it's touch and go above -O3, but most of these bogons are
mozilla and GUI related when it comes to complex thread handling. For
more simple single threaded procs, the bugs get found out about pretty
quickly an
t the answer
> is. :-)
I think the newbie/l33t geek appeal of being able to say something's
compiled and works with -O6 is probably worth more in terms of
marketing than it is interms of actual technical merrit. Those that
need 10K lookups per second should be se
f competence assumed
when someone installs this particular version from the tree. I've
also slapped up some big warnings to make sure that it's developers
only. At the moment, however, I think I'll probably roll my own
tarballs when an island of stability has been found unless the
sn
t; potentially dangerous. If -O3 is a good idea, we should make the
> change for the appropriate platforms in the official source, and let
> it get the widespread testing it requires.
Agreed, but the testing's got to start someplace. :~) The -O3 is a
tunable that you can optiona
much of that done and taken care of as possible would probably be
appreciated and enjoyed by others. It's not fool-proof, don't get me
wrong, but there's certainly some of that that can be automated, and
with tunables I'd like to for usabilities sa
e slick to see it ship with 7.3beta2. 'nother few
weeks before beta2 or is it right around the corner?
For those interested in PostgreSQL + FreeBSD, I have a patch pending
approval that will let developers toggle between a devel port and the
stable release for all ports that depend on Postg
t with disastrous results ...
>
> What method will be employed instead?
Anyone thought about using GeoIP and writing a script that'd dump the
database into something that could be postgresql usable? Just a
thought. -sc
--
Sean Chittenden
---(end of broadcas
27;ll get around to touching down on all of the various files no
promises, I'm getting ready to move. -sc
--
Sean Chittenden
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
revent millions of these:
NOTICE: ROLLBACK: no transaction in progress
-sc
--
Sean Chittenden
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
th autocommit set to off, the
complexity for tracking that in application is getting pretty
gnarly. -sc
--
Sean Chittenden
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
79289940828,0.103550295857988),(-0.322485207100592,0.0739644970414201)
|
(-0.301775147928994,0.124260355029586),(-0.301775147928994,0.124260355029586)
==
--
Sean Chittenden
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
?
It does, thank you. I've just updated the -devel port to 7.3b4,
hopefully the mirrors will pick up the bits soon. -sc
--
Sean Chittenden
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
work with. If anyone
runs across any serious problems on FreeBSD, let me know ASAP.
-sc
--
Sean Chittenden
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
eird platform dependency involved. What's your platform
> >> again?
>
> > I do a make distclean.
>
> > FreeBSD 4.7
>
> I'm still not able to duplicate any problem. Any other FreeBSD folk see
> inet regression failures in
ug:: In brainstorm mode. Anyway, a few names:
auto_order_join
auto_order_join_max
auto_reorder_table_limit
auto_collapse_join
auto_collapse_num_join
auto_join_threshold
When I'm thinking about what this variable will do for me as a DBA, I
think it will make the plan more intelligent by reordering the
we say large page tables? :)
You need an actual 64bit CPU to access more than 4GB of RAM without
paying for it through the nose. -sc
--
Sean Chittenden
msg27765/pgp0.pgp
Description: PGP signature
e of by DBAs that are intentionally performance
tuning their database, but for those that do, it could be a massive
win. Thoughts? -sc
--
Sean Chittenden
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
nges from a log file.
After a threshold, it could be more efficient than having transaction
B re-run its queries.
Like I said, it ain't perfect, but what would be a better solution?
::shrug:: Even OODB's with stats agents have this problem (though
their overhe
bit encodings (UCS-2, UCS-4, UTF-16) is on the TODO list, it might
be nice to keep this in mind and let Ruby maintain it instead of
PostgreSQL.
-sc
--
Sean Chittenden
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
s no huge press for this, I should have the time do do
this in a few weeks if someone doesn't beat me to it.
--
Sean Chittenden
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
do
this, but we'll see... -sc
--
Sean Chittenden
PGP signature
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Jul 2001 22:09:21 -0700
From: Sean Chittenden <[EMAIL PROTECTED]>
To: Darren Johnson <[EMAIL PROTECTED]>
Subject: Re: [HACKERS] IDEA: Multi-master replication possible through
spread
+(or even master-slave)...
Message-ID: <[EMAIL PROTECTED]>
References: <[EMAIL PROTECTED]>
> Some of you got bounces over the last two weeks. I did't get any email.
> Is there a way to have the messages of mailing list L between dates X and
> Y have sent to me with a majordomo command?
echo "help" | mail [EMAIL PROTECTED]
--
Sean Ch
server" config
mkdir /tmp/cvsroot
chmod 1777 /tmp/cvsroot
chown root.wheel /tmp/cvsroot
I think that should do it... -sc
--
Sean Chittenden
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
first open source database
> to do something truly useful with XQuery concepts.
Um, why change the backend at all? Why not have libpq do the
interference mapping between the front end and backend so that we can
leave the backend alone? Seems like a simple application of a good
SAX parser t
e notoriously slow (slower than NFS) at sending files to
clients. -sc
--
Sean Chittenden
pgp0.pgp
Description: PGP signature
nder-hyped. Historically, PostgresSQL has been consistently
^^ ^^^
ahead of MySQL in enterprise database features with support of
transactions and stored procedures."
heh, understatement of the year++ for an understated project.
-sc
--
Sean Chittenden
---(e
eone said it was OK in a closed environment or
> something. Maybe we need to document that it is not recommended.
Keep krb4 in the tree for 7.4, but before 7.4 gets released, the
documentation and release notes need to state that krb4 has been
depreciated and that it will b
do any recent upgrades and what
version of FreeBSD?
-sc
--
Sean Chittenden
pgp0.pgp
Description: PGP signature
and checked.
*wanders off to go read -committers*
-sc
--
Sean Chittenden
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
X has the latest and greatest version of
gdtoa, which fixes many standardization bits in FreeBSD's floating
point routines.
Tom, you said you needed a shell way of detecting this, does the
following work?
if [ "`uname`" = FreeBSD ]; then
if [ "`sysctl -n kern.osreldate`&quo
tests fail on 5.0 given it should have a tiny user base in
a month.
Making the proposed change above fixes the regression tests on my
5.1... I don't have any 4.X machines I can play with at the moment,
Rod would have to test that.
-sc
--
Sean Chittenden
---(end of br
5.X cases even though their handling is different. -sc
--
Sean Chittenden
pgp0.pgp
Description: PGP signature
that code's probably 6-8 years old
at this point. If you wanted to be super judicious about preserving
backward compatibility, you could add freebsd2 and freebsd3 to the
list too.
-sc
--
Sean Chittenden
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
ser space, the buffer cache is what helps
speed up PostgreSQL since PostgreSQL leaves all of the caching
operations and optimization/alignment of pages up to the OS (much to
the behest of madvise() which could potentially speed up access of the
VM, but I won't get into that... see TODO.mm
s load or
the disk buffer being emptied and having to be refilled, I'm not sure,
but thinking about it, use of a GUC threshold to have an FD marked as
O_DIRECT does make sense (0 == disabled and the default, but tunable
in Kbytes as an admin sees fit) and could be nice for big queri
obvious to me what the change ought to be though.
>
> Please try the attached patch.
>
> I'll try to change kerberos 4 later if I can find some
> documentation about it. Especially the krb_sendauth() function.
>
> Does Kerberos 4 support other protocols than ipv4?
Not
mechanism kicks in and takes effect. Given that the planner
has an idea of how much data it's going to read in in order to
complete the query, seems easier/better to mark the fd O_DIRECT.
*shrug*
-sc
--
Sean Chittenden
---(end of broadcast)-
o the platter in a
single write by the OS as possible, circumventing that would be
insane (though useful possibly for embedded devices with low RAM,
solid state drives, or some super nice EMC fiber channel storage
device that basically has its own huge disk cache).
2) Last I checked Po
L buffer
> cache to handle most of the benefits of O_DIRECT, without the
> read-only buffer restriction.
I don't see how this'd be an issue as buffers populated via a read(),
that are updated, and then written out, would occupy a new chunk of
disk to satisfy MVCC. Why wou
O_DIRECT makes writes jump the gun
18:04 <@seanc> got it
18:05 <@seanc> zb^3: is that required in the implementation or is it a bug?
18:06 * seanc is wondering whether or not he should bug dillion about this to
get things working correctly
18:07 <@zb^3> it's a
id load environment that'd let
any O_DIRECT benchmark be useful isn't trivial.
-sc
--
Sean Chittenden
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
he userland API will remain stable (it'll just get more efficient in
6, not that it's not fast as is).
http://lists.freebsd.org/pipermail/cvs-all/2003-March/000261.html
-sc
--
Sean Chittenden
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
on. O_DIRECT eliminates one of these
copies: nevermind the doubling up of data in RAM.
--
Sean Chittenden
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
, but if
things lag for an instant, the platter will have to make another
rotation before the call comes back to the userland.
Now that I think about it, the optimal case would be to anonymously
mmap() a private buffer that does the read() writes into that way the
HDD could just DMA the data into
es too given the number of security vulnerabilities
associated with the call. :-]
-sc
--
Sean Chittenden
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
nsigned int __attribute__((__mode__(__DI__))) __uint64_t;
#else
/* LONGLONG */
typedef long long __int64_t;
/* LONGLONG */
typedef unsigned long long __uint64_t;
#endif
-sc
--
Sean Chittenden
---(end of broadcast)---
TIP 8: explain analyze is your friend
e parent when a client calls
PQfinish(), not in between transactions.
> Also it sounds to me like the postmaster will now become a
> performance bottleneck, since it will need to be involved in every
> transaction start.
Well, I'm pretty sure you're under the impression I'm chasing a
different goal than the one I'm working toward.
-sc
--
Sean Chittenden
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
l.
Tom, I know you just replaced a bunch of select() calls with poll().
Would you mind if I went through and patched things to use libevent's
abstraction layer?
Once this is done, then I'll go back and use libevent for the
persistent connections goo. -sc
--
Sean Chittenden
---
D utc_date = NOW();
SELECT * FROM report_user_cat_count AS rucc WHERE user_id = 42;
SELECT * FROM report_user_cat_count AS rucc WHERE user_id < 1000 AND utc_date >
'2003-01-01'::TIMESTAMP WITH TIME ZONE;
And various timestamps back to 2002-09-19 and user_id's IN(1,42).
-sc
--
Se
ils/adt/selfuncs.c isn't right for multi-column
indexes, esp for indexes that are clustered. I don't know how to
address this though... Tom, any hints?
FWIW, this is an old data/schema from a defunct project that I can
give people access to if they'd like. -sc
--
Sean Chittenden
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
ter results in my case, it
isn't very adaptive given it uses arbitrary magic numbers.
> >If I manually set the indexCorrelation to 1.0, however, the planner
> >chooses the right plan on its own
>
> Ok, with indexCorrelation == 1.0 we dont have to discuss interpolation
> methods, because they all return min_IO_cost.
>
> >Which suggests to me that line 3964 in
> >./src/backend/utils/adt/selfuncs.c isn't right for multi-column
> >indexes, esp for indexes that are clustered.
>
> Agreed.
>
> > I don't know how to
> >address this though...
>
> I guess there is no chance without index statistics.
>
> >FWIW, this is an old data/schema from a defunct project that I can
> >give people access to if they'd like.
>
> Is there a dump available for download?
Sure, let me post it.
http://people.FreeBSD.org/~seanc/pgsql/rucc.sql.bz2
-sc
--
Sean Chittenden
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
hat the use of those comes at great
expense to the CPU (which is inline with a few other papers that I
read). The idea of precomputing values piqued my interest and I
thought was very clever, albeit space intensive. *shrug*
-sc
--
Sean Chittenden
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Index Scan using report_user_cat_count_html_bytes_idx on report_user_cat_count rucc
(cost=0.00..112165.07 rows=31893 width=64) (actual time=68.64..85.75 rows=514 loops=1)
Index Cond: (html_bytes > 800::bigint)
Total runtime: 97.75 msec
(3 rows)
*shrug* A low ind
ith larger queries, it's problematic to not be able to use a
cursor in addition to the prepared statement.
-sc
--
Sean Chittenden
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
only Kerberos 5 is recommended. Kerberos 4 is
> considered insecure and no longer recommended for general
> use.
>
iirc, we were going to depreciate kerberos 4 in the 7.4 release notes
and remove support for it for 7.5, giving users one full release cycle
to move to krb5.
e BSDs dumped support for krb4 from the base, I don't recall a
single email from someone complaining as almost everyone who uses krb
uses hiemdal or MIT krb5. -sc
--
Sean Chittenden
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
read tests, I'd be interested
in those results to see if it's still 8% faster. In using 16K blocks,
I'd imagine this'll make using seq scans cheaper on FreeBSD.
Comments? -sc
--
Sean Chittenden
---(end of broadcast)---
TIP 3
gt; at configure time, and I don't much want to add it.
The patch gets applied when the port gets built, so there doesn't need
to be a configuration option for it for this to work.
--
Sean Chittenden
---(end of broadcast)---
TIP 5: Have y
se results to see if it's still 8% faster.. I imagine this'd
make seq scans cheaper on FreeBSD.
Comments? -sc
--
Sean Chittenden
--- Begin Message ---
> > > Like all benchmarks, I doubt these are perfect (or even close)
> > > examples of real-world use.
> >
ITA, which is why I asked for comments.
Other than you feeling uneasy about the possibility of uncovering bugs
because this hasn't been widely done like this before, do you have any
other concerns, or do you think the possibility of finding bugs very
likely?
-sc
--
Sean Chittenden
'nother test in support of 16K blocks for FreeBSD, this time it was
25% faster to import. -sc
--
Sean Chittenden
--- Begin Message ---
Hi.
I'm implementing postgresql 7.3.4 on FreeBSD 5.1, and
decided to place the pgsql-folder on it's own
partition so it was easier to test whi
ma. I have some read tests I'm going to perform here in a bit,
but I'm waiting for kde to finish compiling before I start testing.
I have another tests machine that I'm going to task with comparing 16K
and 8K blocks. It's not SCSI, but I don't have any available machines
tha
> Does anybody know of a BSD licensed signal implementation that
> compiles on win32?
See how Apache handles this problem (via APR?).
-sc
--
Sean Chittenden
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to
Is it really necessary for postgres to be linked with ncurses (288K)
and readline (156K)? It's .5M, not the end of the world, but it seems
excessive. I know the postmaster has a CLI interface, but does it
really require ncurses or readline? -sc
--
Sean Chittenden
is to change the
LDFLAGS, I was thinking about chasing down where postgres is linked
and splitting apart LDFLAGS into two sets of LDFLAGS: LDFLAGS_CLI and
LDFLAGS (or LDFLAGS_DAEMON, or some such). It's chump, but a few ms
here and there, or a little more IO there eventually add up,
esp
ng
contexts between procs, but that's a pretty weak argument for only .5M
of shared RAM. For some reason I thought it exec()'ed a child with
the args necessary for it to read in a postgresql.conf. Looks like
the comment in backend/storage/ipc/ipci.c is out of date t
r DBAs. If ``'s are needed in the pl language, they can
be nominally included with a \`\`, but given their relative rareness
compared to ' or ", I'd think the addition of ` would be welcome and
much less cumbersome/easier to remember than other options
BEGIN(SQL);
return(tSTRING);
} else {
/* Do nothing until we hit a match */
}
}
.{
/* Not sure these func names off the top of my head: */
pg_append_str_to_buf(lit_val, yytext, yyleng);
}
%%
/* Or something similarly
@ for abs (rarely seen in the wild
from my experience, and has a lower match precedence in flex).
> In any case, @ and % are valid (and popular) operator names in
> Postgres, so we could not use them for this purpose without removing
> that meaning, which would be
much success.
>
> > We could call it meta-quoting, or alternative quoting, maybe.
>
> Those seem pretty unmemorable and content-free, though. Any other ideas
> out there?
literal text blocks
literal quotes
literal text sections
-sc
--
Sean Chittenden
-
1 - 100 of 128 matches
Mail list logo