.html (that doesn't appear to support
anything but HEAD, but I know there's other sites out there that provide
similar tools for our code.)
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Data in Trouble? Get it in Treble! http://BlueTreble.com
--
Sent via pgsql-hacker
Objects for
this database are stored.
There's also nothing preventing someone from creating a 'next
generation' LO PGXN extension that could be brought into core if enough
people show interest. That's probably the best route to get changes to
the existing LO infrastructure ma
in fn_extra. I realize you can figure it out from
fn_mcxt, but I don't know that that's terribly obvious to others.
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Data in Trouble? Get it in Treble! http://BlueTreble.com
--
Sent via pgsql-hackers mailing list (pgsql-hacker
the
initdb option in the first place.
#2 seems reasonable. #1 seems like it's partway up the molemountain.
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Data in Trouble? Get it in Treble! http://BlueTreble.com
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresq
arbitrary length and arrays don't support that.
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Data in Trouble? Get it in Treble! http://BlueTreble.com
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www
would be
overcome by the explicit testing we would need to have for approved modules.
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Data in Trouble? Get it in Treble! http://BlueTreble.com
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
-tester.org/ results for all
modules, which would help with that. In the meantime you can hit that site
itself. Awesome work by Tomas Vondra.
A number of modules also run Travis-CI. Might be worth having a way for
a module to provide it's status .png.
--
Jim Nasby, Data Architect, Blue T
ting of edge cases (such as MXID
wrap) and then combining that with other forms of testing, such as
pg_upgrade and streaming rep. testing. Test things like "What happens if
we pg_upgrade a cluster that's in danger of wraparound?"
--
Jim Nasby, Data Architect, Blue Treble Consulti
ning. ISTM
that there's a lot of hand-waving that happens around use cases that
could probably be clarified with end user input.
FWIW, I don't think the blocker here is git or building from source. If
someone has that amount of time to invest it's not much different than
gr
ell you much; you want to know how
much column data was actually pulled out.
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Data in Trouble? Get it in Treble! http://BlueTreble.com
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make chan
;ll need to come up
with some concrete scenarios and provide data on where all the
performance hit actually is.
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Data in Trouble? Get it in Treble! http://BlueTreble.com
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgr
On 6/5/15 10:49 AM, David E. Wheeler wrote:
On Jun 5, 2015, at 12:34 AM, Jim Nasby wrote:
A number of modules also run Travis-CI. Might be worth having a way for a
module to provide it's status .png.
Right. Just stick it in your README.
http://blog.pgxn.org/post/116087351668/badge
Postgres is essentially impossible. Your only option is to
put implicit or assignment casts in and cross your fingers, or to do
only explicit casts and force the user to cast everything (which is a
PITA). Even a json_pointer type may not help this much unless we have
some way to reliable tran
to have any kind of
incremental matview update.
Just trying to keep things in perspective. :)
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Data in Trouble? Get it in Treble! http://BlueTreble.com
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To
hugely helpful when using gdb.
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Data in Trouble? Get it in Treble! http://BlueTreble.com
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
workers. There's now enough parallelism
infrastructure that it shouldn't be too hard to hack up a quick test of
that.
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Data in Trouble? Get it in Treble! http://BlueTreble.com
--
Sent via pgsql-hackers mailing list (pgsql-h
On 6/14/15 9:50 AM, Alvaro Herrera wrote:
+ values[0] = MultiXactState->oldestMultiXactId;
What about oldestOffset and offsetStopLimit? Seems those would be useful
too. Looks good other than that.
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Data in Trouble? Get
e had the ability to
access columns in a referenced FK table from a referring key; something
like SELECT customer_id.first_name FROM invoice (which would be
translated to SELECT first_name FROM invoice JOIN customer USING(
customer_id )).
--
Jim Nasby, Data Architect, Blue Treble Consul
be a problem as long as you don't read too
often from it?
The stats collector is a known problem under certain circumstances, so
improving it would probably be a good thing. The first thing that comes
to mind is splitting it into more files.
--
Jim Nasby, Data Architect, Blue Treble Cons
On 6/17/15 2:04 PM, Alvaro Herrera wrote:
Jim Nasby wrote:
Related to idea of an 'auto join', I do wish we had the ability to access
columns in a referenced FK table from a referring key; something like SELECT
customer_id.first_name FROM invoice (which would be translated to SELECT
int32 into a signed int32 (which is what the SQL int
is). That's why it's returning a bigint.
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Data in Trouble? Get it in Treble! http://BlueTreble.com
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
On 6/12/15 9:17 PM, deavid wrote:
(upper(codagencia::text) );
FWIW, you should consider using citext for these cases; it would let you
cut down on the number of indexes (by 50%?).
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Data in Trouble? Get it in Treble! http
don't
know where we'd put it (I doubt users would go looking in the libpq api
docs to find it...)
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Data in Trouble? Get it in Treble! http://BlueTreble.com
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgres
cification
though, so presumably this could be added later.
(Presumably, only immutable functions would get transmitted, even if there
are mutable functions present in a marked extension.)
+1
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Data in Trouble? Get it in Tr
etter to get this committed without more
than we have now than to do without it though...
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Data in Trouble? Get it in Treble! http://BlueTreble.com
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make
bgworker could follow behind the seqscan.
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Data in Trouble? Get it in Treble! http://BlueTreble.com
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org
On 6/5/15 3:51 PM, Alvaro Herrera wrote:
Jim Nasby wrote:
On 6/5/15 2:08 PM, Petr Jelinek wrote:
That's a good point, and it won't get any better if/when we add the json
point support in 9.6 since the syntax would be something like select
jsonb '{"a":"1",
On 6/22/15 9:00 AM, Tom Lane wrote:
Jim Nasby writes:
On 6/19/15 10:35 AM, Tom Lane wrote:
On the other hand, you could argue that improving the string is going
to break clients that do the right thing (even if klugily) in order
to help clients that are doing the wrong thing (ie, failing
what you're describing (though, I believe even more
granular) and have a bgworker accumulating that information.
[1] http://www.pgcon.org/2015/schedule/events/809.en.html
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Data in Trouble? Get it in Treble! http://BlueTreble.com
-
nstrated[1] getting progress stats for long running
queries[2] at pgCon 2013. Perhaps some of that code would be useful here
(or better yet perhaps we could include at least the measuring portion
of his stuff in core... ;)
[1] https://www.pgcon.org/2013/schedule/events/576.en.html
[2] https://
ay the RI triggers do.
What would be a lot better is if we had better control over function and
operator resolution.
[1]
https://github.com/decibel/variant/commit/2b99067744a405da8a325de1ebabd213106f794f#diff-8aa2db4a577ee4201d6eb9041c2a457eR846
--
Jim Nasby, Data Architect, Blue Treble C
K, updated patch attached.
Patch applied.
I only just noticed this item when I read the release notes. Should
we bother warning when used on an unlogged table?
Not really; but I think the bigger question at this point is if we want
to change it this late in the game.
--
Jim Nasby, Data Archi
be fixed in 9.5 - because it is limiting factor for bgworkers
usage in 9.5.
Anything ever happen with this? I agree that LOG is to high for
reporting most (if not all) of these things.
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Data in Trouble? Get it in Treble! http
uld turn on individual reports. If we had that we'd just make these
particular ereports DEBUG1 and not worry about it because you could
easily turn them on when needed.
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Data in Trouble? Get it in Treble! http://BlueTreble.com
Presumably handling that requires all the stuff that's
discussed already and you might as well just handle the recording in
user space. But maybe someone has some clever ideas there...
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Data in Trouble? Get it in Treble! http://
On 6/23/15 9:45 AM, Pavel Stehule wrote:
2015-06-23 1:56 GMT+02:00 Jim Nasby mailto:jim.na...@bluetreble.com>>:
On 6/22/15 2:46 AM, Pavel Stehule wrote:
FOREACH key, val IN RECORD myrow
LOOP
IF pg_typeof(val) IN ('int4', 'double
both
backends and bgwriter...
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Data in Trouble? Get it in Treble! http://BlueTreble.com
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
a float or a numeric?). But maybe JSON is good enough.
[1] The one OO-ish data feature I'd like is the ability to de-reference
a foreign key "pointer". So if
CREATE TABLE b( a_id int REFERENCES a);
then have
SELECT a_id.some_field FROM b;
transform to
SELECT a.some_field FR
boil the ocean, but if
we keep piecemealing this without more though we're going to keep
getting more warts (like a lot of the gotchas we have with arrays).
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Data in Trouble? Get it in Treble! http://BlueTreble.com
ugh, and really merits a separate thread. For Pavel's issue I'm all
in favour of just changing the log message, I think LOG is way too
high for something that's internal implementation detail.
+1.
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Data in Trouble? Get it in
something dumb...
If I replace the StaticAssert with
Assert(OidIsValid(object_classes[MAX_OCLASS - 1])) it works find and
initdb will fail if that assert trips.
I've attached the broken StaticAssert version. Also added a warning
comment to the enum.
--
Jim Nasby, Data Architect, Blue Treble
tty common scenario.
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Data in Trouble? Get it in Treble! http://BlueTreble.com
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
an to make *partitioning* work.
It occurs to me that we could run the BEFORE triggers and then pass the
new tuple to a user-supplied function that returns a regclass. That
would allow us to know exactly which child/partition the UPSERT should
be attempted in.
--
Jim Nasby, Data Architect, Blue T
-c 'select * from pg_class where false' -x
(0 rows)
$
Was that intentional?
That's consistent with what > 0 rows does, so it seems the correct thing
to do. Going from "(No rows)" to "(0 rows)" is going to break things
anyway, so I don't see a ba
e is https://github.com/slux/PostgreSQL-Performance-Farm; but
it hasn't been touched in 5 years. :(
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Data in Trouble? Get it in Treble! http://BlueTreble.com
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To
the new logic looks correct.
It'd actually be nice if we also logged the most recent XID that
actually got frozen. That's the XID that Hot Standby would actually care
about (not the freeze limit).
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Data in Trouble? Get it in
inly
necessary sometimes).
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Data in Trouble? Get it in Treble! http://BlueTreble.com
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
fresher eyes than the
last time I looked.
Isn't this the kind of thing Coverty's supposed to find?
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Data in Trouble? Get it in Treble! http://BlueTreble.com
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.or
Is there a way to determine the operator that resulted in calling the
operator function? I thought fcinfo->flinfo->fn_expr might get set to
the OpExpr, but seems it can be a FuncExpr even when called via an
operator...
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
D
On 7/3/15 2:33 AM, Heikki Linnakangas wrote:
On 07/03/2015 01:20 AM, Jim Nasby wrote:
Is there a way to determine the operator that resulted in calling the
operator function? I thought fcinfo->flinfo->fn_expr might get set to
the OpExpr, but seems it can be a FuncExpr even when called
ipulations on
a SQL 2008-compliant DBMS.
AFAIK HTSQL is very happy producing SQL; why not just let it hand SQL to
Postgres (which it already does...)
Have you by chance talked to Clark or Kirill about this?
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Data in Trouble? Ge
On 7/4/15 12:33 AM, Tom Lane wrote:
Jim Nasby writes:
On 7/3/15 2:33 AM, Heikki Linnakangas wrote:
On 07/03/2015 01:20 AM, Jim Nasby wrote:
Is there a way to determine the operator that resulted in
calling the operator function? I thought
fcinfo->flinfo->fn_expr might get set to the
general use on production systems.
+1. I don't think there's value to keeping this stuff away from DBAs.
Perhaps it should default to only SU being able to execute it though.
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Data in Trouble? Get it in Treble! http://Blue
ou can only have one "development" package installed
at once. We've pushed to change this to no effect. :/
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Data in Trouble? Get it in Treble! http://BlueTreble.com
--
Sent via pgsql-hackers mailing list (pgsql-hackers@post
h is a
very short-term thing. It would be better to find a way to handle that
differently.
In any case, that should definitely be a separate discussion from this
patch.
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Data in Trouble? Get it in Treble! http://BlueTreble.com
talking about. It's talking about
exposing ereport as a SQL function, without altering the rest of our
logging behavior.
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Data in Trouble? Get it in Treble! http://BlueTreble.com
--
Sent via pgsql-hackers mailing list (pgs
se case is using this to finally ditch all the old VACUUM FULL
code in HeapTupleSatisfies*().
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Data in Trouble? Get it in Treble! http://BlueTreble.com
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make
ch as a wrapper sql function for ereport.
You might want to present a plan for that; it's not as trivial as it
sounds due to how ereport works. In particular, I'd want to see (at
minimum) the same functionality that plpgsql's RAISE command now
provides (errdetail, errhint, etc).
--
On 7/13/15 4:02 PM, David Christensen wrote:
On Jul 13, 2015, at 3:50 PM, Jim Nasby wrote:
On 7/13/15 3:26 PM, David Christensen wrote:
* Incremental Checksums
PostgreSQL users should have a way up upgrading their cluster to use data
checksums without having to do a costly pg_dump
(SSD) and the toast table on slow storage
(spinning rust).
I've seen humoungous toast tables that are barely ever read for tables
that are constantly a couple times in the field.
+1. I know of one case where the heap was ~8GB and TOAST was over 400GB.
--
Jim Nasby, Data Architect, Blue Treble C
h all the pain of handling this manually (as well as
all the limitations that go with that).
If it's easy to fix the bloat problem at the same time as adding GLOBAL
TEMP then great! But there's no reason to reject this just because it
doesn't fix that issue.
--
Jim Nasby, Data A
nce_work_mem. ISTM that when that happens you'd definitely want
a better idea of what's going on...
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Data in Trouble? Get it in Treble! http://BlueTreble.com
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.
u're at, while
every alternative format I've seen is terse enough to be very clear on a
single line.
I'm guessing it'd be really ugly/hard to support at least this GUC being
multi-line?
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Data in Trouble? Get it
view that's the
equivalent of SELECT * FROM for every sequence in the
database. That would let you get whatever info you needed.
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Data in Trouble? Get it in Treble! http://BlueTreble.com
--
Sent via pgsql-hackers mailing
W, take a look at MADlib svec[1]... ISTM that's just a special case of
what you're describing with entire grids being zero (or vice-versa).
There might be some commonality there.
[1] https://madlib.incubator.apache.org/docs/v1.8/group__grp__svec.html
--
Jim Nasby, Data Architec
ted if different projection methods
are involved. I don't know if PostGIS depends on what these macros are
doing or not. If it doesn't, perhaps it would be sufficient to lop of
the last few bits of the significand. ISTM that'd be much better than
what the macros currently do.
BTW, I su
e
confusing, and I don't see any options for parallelism that are any clearer.
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com
855-TREBLE2 (855-873-2532) mobile: 512-569-
o
away, *especially* if the [] notation allowed things like a slice and a
list of values (ie: json['foo', 'bar', 'baz'] = '[42,{"my": "nice
object"},"with a random string"]'. Or = row(42, ...).
--
Jim Nasby, Data Architect, Blu
not enough when different GRSes are involved?
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com
855-TREBLE2 (855-873-2532) mobile: 512-569-9461
--
Sent via pgsql-hacke
On 5/30/16 1:01 PM, Andrew Gierth wrote:
Returning an array containing the values of all capture groups might be
more useful (substring returns the value of the first capture group if
any, otherwise the matched string).
+1.
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
as a table column
So that's 5 x 2 (once for domain[], once for create type blah(x
domain[])) test cases. There might be some other cases that are missing
(what cast testing needs to happen?)
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architectur
I'm pretty sure this is a typo...
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com
855-TREBLE2 (855-873-2532) mobile: 512-569-9461
diff --git a/src/backend/access
scover; I doubt most
users are aware that you *can* analyze individual columns.
Is there any significant advantage to not analyzing all columns? Only
case I can think of is if you have a fair number of columns that have
been toasted; otherwise I'd think IO would completely swamp any other
n some of these scenarios, because it's
so difficult to put the system into that state to begin with. Stuff that
depends on burning through a large number of XIDs is an example of that.
(To be clear, I'm talking about unit-test kind of stuff here, not
validating an existing system.)
ill has to support 3 numbers
would also be a wart. We've lived with the parsing wart this long, so
lets just add an explicit output version to 10.0.
Any ideas on naming for such a function? version_detail()? I suppose
while we're at this we might as well provide the compile details as
ver an encrypted FS, other than a feature
comparison checkmark...)
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com
855-TREBLE2 (855-873-2532) mobile: 512-569-9461
--
S
that presumably the explain penalty would be a moot
point.
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com
855-TREBLE2 (855-873-2532) mobile: 512-569-9461
--
Sent vi
hat doesn't currently exist anyway. So
no matter what, you won't be able to use it if you're interested in
<10.0 (or <9.6 if we went with one of the other proposals).
Unless folks were thinking this is something that would be backpatched?
--
Jim Nasby, Data Architect, Blue Tr
On 6/8/16 4:36 PM, Bruce Momjian wrote:
Just a follow-up, but even with a randomized correlation order, it seems
25% restrictivity generates a Bitmap Index Scan:
AFAIK we do the bitmap heap scan in heap order, thereby eliminating the
effect of correlation?
--
Jim Nasby, Data Architect, Blue
On 6/14/16 3:38 PM, Joshua D. Drake wrote:
On 06/14/2016 12:46 PM, Jim Nasby wrote:
Any ideas on naming for such a function? version_detail()? I suppose
while we're at this we might as well provide the compile details as well.
version(detail) or version(verbose)
I don't think tha
On 6/14/16 3:56 PM, Tom Lane wrote:
Jim Nasby writes:
On 6/14/16 3:01 PM, Robert Haas wrote:
This seems kind of silly, because anybody who is writing code that
might have to run against an existing version of the database won't be
able to use it. The one thing that absolutely has to be
to pg_config? It's common to need to know what version you're handling
in a Makefile, and today that's pretty ugly (especially when something
is stamped as beta, since it breaks assumptions about numeric).
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in
views, but
rather functions that serve specific purposes. For table bloat that
means a function that returns what the heap size should be based on
pg_stats. For locking, it means providing information about which PID is
blocking which PID. After that, most everything else is just window
dressing.
--
ctions. Not the nicest
way to handle this problem, but it is workable and having a regex
example available for people to start with would be very helpful.
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in T
for everything that's varlena (AFAICT plperl already suffers from this).
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com
855-TREBLE2 (855-873-2532) mobile: 512-569-94
n't have a choice about
that unless we expressly forbid arrays where any of the elements of
*dims were 0 (which I suspect we should probably do anyway... I don't
see how you can do anything with a 2x0x3 array...)
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts
s all-visible for
index-only purposes. If it's an insert mostly table, it can be a long
while till vacuum comes around.
ISTM that's something that should be addressed anyway (and separately), no?
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Archi
On 7/1/16 3:43 PM, Andres Freund wrote:
On 2016-07-01 15:42:22 -0500, Jim Nasby wrote:
On 7/1/16 2:23 PM, Andres Freund wrote:
The only
cost of that is that vacuum will come along and mark the page
all-visible again instead of skipping it, but that's probably not an
enormous expense in
testing. Though I do think something
that's sorely needed is the ability to test stuff at the C level.
Sometimes SQL is jut too high a level to verify things.
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Troubl
t may have some. Is that an oversight?
Seen as how you used to be able to illegally twerk NOT NULL status on
children (and maybe still can), I'd bet this is a bug...
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data
?
In a lot of situations ("top" for instance) only a limited number of
characters can be displayed from a process title. I'm hesitant to add
fields to that string that we don't really need.
Could we make this configurable, similar to log_line_prefix?
--
Jim Nasby, Data Ar
because arrays are a
PITA? Is it too hard to call functions?
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com
855-TREBLE2 (855-873-2532) mobile: 512-569-9461
--
Sent
ta, and because of it's binary nature
the odds of some kind of a corruption event happening are far higher
than with something like londiste. Certainly many environments don't
have those concerns though. Having options are good.
--
Jim Nasby, Data Architect, Blue Treble Consulti
Depending on how it was
structured, it might also insulate the database from having to panic if
a function crashed it's process.
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://Blu
a function in that extension:
EXTENSION MODE citus;
master_create_distributed_table 'github_events', 'created_at', 'append';
EXTENSION MODE;
instead of SELECT master_create_distributed_table('github_events',
'created_at', 'append');
ob
On 7/21/16 11:46 AM, David Fetter wrote:
> Can't you implement this as a extension?
Yes. In that case, I'd want to make it a contrib extension, as it is
at least in theory attached to specific major versions of the backend.
Howso?
--
Jim Nasby, Data Architect, Blue Treble Consu
ot supported, but it would be
nice if I could just do CREATE TYPE c AS (t text NOT NULL, i int);
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com
855-TREBLE2 (855-873-2532)
L::c).t
IS NULL might be allowed (special case retrieving field values from a
composite that's not actually defined).
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com
e additional
support that would be needed in expanded objects themselves.
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com
855-TREBLE2 (855-873-2532) mobile: 512-569-9461
On 7/22/16 1:58 PM, Andres Freund wrote:
On 2016-07-22 13:51:31 -0500, Jim Nasby wrote:
Another option would be to remember the
tuple offsets (NOT attcacheoff) that have
been computed as well as whether a
varlena attribute has actually been
deformed. That eliminates the need to
pre-declare what
1801 - 1900 of 2230 matches
Mail list logo